Read data from 3 tables in sender JDBC Adapter

[Former Member]

Hi All,

I doing a scenario JDBC to IDOC I need to read 3 tables of ORACLE. how JDBC sender adapter will retrieve data from more than 3 ORACLE tables and also i need to update control status fields of these tables.

Please provide me the syntax for the select and update.

Thanks in Advance

Regards,

Nisha

[jagesh_lakdawala]

Hi Nisha,

As you require Select & Update both in three different ORACLE Tables then you should

use Store procedures for Sender JDBC Adapter.

If you require only Selection of data from three table then in such a case even

JOIN Select Query on different tables cab be use.

Thanks

Regards,

Jagesh

[Former Member]

Hi Jagesh Lakdawala,

Please provide me the syntax for the select and update statement and also if i go for stored procedure then where can i use this. I know that we need to use select execute 'stored_procedure1name' statement. where we are writing and storing the stored procedure.

Thanks,

Nisha

[Former Member]

Hi,

Chk dis out...

http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

[jagesh_lakdawala]

Hi,

Select Syntax:- select Table1.Field1, Table1.Field2, Table2.Field3, Tabl2.Field4

From Table1 , Table2 where Table1.Field1 = Table2.Field3.

Similary use this Syntax for three Tables.

Update Syntax: -

In SP Check if Data Seletion is suceesful then Use the seperate Update statement for each table.

like Update Table1 set Field5 = 'Value'

where Field1 = 'Value'.

Also use the refernce link provided by Mr.Vinithra Iyangar.

Thanks

Regards

Jagesh

[Former Member]

Hi... Jagesh I am Miss not Mr.