JDBC Sender

[former_member189441]

HI,

Can i Select data from 3 tables using JOIN statement in sender JDBC adapter??

If so, Can i update all 3 tables using Update query parameter in JDBC sender??

i have to select from 3 tables and update fields in 3 tables..

Thanks

Murali

Edited by: murali krishna on Mar 8, 2010 10:52 AM

[Former Member · Accepted solution]

Hi Mural,

Yes,u can use Joins to select data from diff tables and also update those table fileds.

Ex:

SELECT table1.column1, table2.column2 FROM table1, table2 WHERE table1.column1 = table2.column1;

SELECT table1.column1, table2.column2 FROM table1, table2, table3 WHERE table1.column1 = table2.column1 AND table1.column1 = table3.column1;

UPDATE:

Update MyTable MT Set (col1, col2) = (Select col3, col4 From tableA TA Where TA.col5 = MT.col5);

http://decipherinfosys.wordpress.com/2007/01/31/update-data-in-one-table-with-data-from-another-tabl...

Thanks

Ravi

[former_member189441 · Accepted solution]

Hi Ravi,

After selecting data like the below select query...

SELECT table1.column1, table2.column2 FROM table1, table2 WHERE table1.column1 = table2.column1;

I have to update Column1 in table1 and table2 eg: if the column1 value is 123 i have to change it to 111 in both tables where we have selected the data..

[former_member189441]

Hi all,

Sorry..

I mean to say SQL scripts..

[former_member189441]

Hi All,

Can we write SAP scripts in Update query paremeter in sender JDBC..??

immediate response is Appreciatable.

Thanks,

Murali

[prateek]

No. What are you thinking about SAP Script doing on external database?

Is use of BPM an option?

Regards,

Prateek

[prateek]

Can i Select data from 3 tables using JOIN statement in sender JDBC adapter??

Yes

Can i update all 3 tables using Update query parameter in JDBC sender??

Unfortunately, only one table update is possible.

Regards,

Prateek

[former_member189441]

Hi Prateek,

Then how can update after selecting the from multiple tables.is there any alternative procedure.

[Former Member]

Hi Murali,

Please refer this ...

This will solve ur doubts

Babu