Reg JDBC Adapter

[Former Member]

Hi Guys,

How to retrieve data from multiple tables using JDBC Adapter and what is stored procedure,how it used in JDBC Adapter

Thanks

[Former Member]

thnx

[JoelTrinidade]

hi Kushee,

A small part of your question was answered by tarang rest i will answer. Regarding stored procedures and how to use them refer

"Calling stored procs in MaxDb using SAP Xi"

/people/sriram.vasudevan3/blog/2005/02/14/calling-stored-procs-in-maxdb-using-sap-xi

"JDBC Stored Procedures"

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

Regards

joel

[Former Member]

Hi,

You can get data from multiple tables by specifying your SELECT query using JOIN on the tables in the sender JDBC comm channel.........In the JDBC msg structure, if you use action as EXECUTE, then you can specify your stored procedure by your JDBC comm channel.......

Regarding what is stored procedure - Stored procedure is just a type of function or a sub-routine having database statements to be executed on the database..........you can specify input parameters also to execute your stored procedure based on the values of your input parameters.

Regards,

Rajeev Gupta

[mf_haq]

Hi,

1. with Udf's we can retrive the data from multiple tables.

2. stored procedure is a temporary buffer, it will do all DML operations, we can use in MM.

rgds,

MF

[former_member206760]

no need of stored procedures..

you can directly write a join select query in the sender Jdbc adapter