Update in JDBC Sender adapter for more than one table

[Former Member]

Dear Friends,

I have to select more than one table in the JDBC sender using the join condition. But i found that update statement is also mandatory in the sender comm channel. I am not going to update any flag after the select but as it is mandatory, i have decided to use the following update statement which wont effect the existing data UPDATE <tablename> set flag = ' ' where flag = ' '.

But in my case i have 3 tables, do i need to update stmts for all the three tables.

if yes how can i do the same.

plz revert back i u couldnt get the queries.

Thanks

Prem

[Former Member · Accepted solution]

Hi,

Just use "Test" in the Update Parameter if you dont want to use Update Stmt.

http://help.sap.com/saphelp_nw70/helpdata/EN/ae/d03341771b4c0de10000000a1550b0/frameset.htm

Regards

Seshagiri

Edited by: N V Seshagiri on Sep 24, 2008 7:15 AM

[Former Member]

am ued chethan answer...can try vijay answer <test>

[Former Member]

HI

UPDATE T1

Set T1.flag =1

where T1.columnA=value1 and T2.columnB=value2

where T1 and T2 are tables in the same database,

and the values (value1 and value 2 ) are provided to XI by SAP based on which the flag need to be updated in T1

write a stored procedure specifying the join and call it in XI.

For doing it in SQL statement only reffer to the below link ..sur you will get help .

Regard's

Chetan Ahuja

[vijay_kumar133]

Hi

in update space write <test> that will solve u r issue..

Regards

Vijay