cancel
Showing results for 
Search instead for 
Did you mean: 

Joins implementation receiver Jdbc Adapter

Former Member
0 Kudos

Hi All

I need some suggestions on the following scenario

Updation of a flag in a table where the column names in the WHERE clause are from two different tables in the same database.

i.e

UPDATE T1

Set T1.flag =1

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

where T1 and T2 are two different tables in the same database,

I want to accomplish this directly using UPDATE in JDBC receiver by using JOIN query in the structure.

kindly reply

thanks

sd

Accepted Solutions (0)

Answers (1)

Answers (1)

bhavesh_kantilal
Active Contributor
0 Kudos

Hi Sd,

You can execute an SQL statement directly in your Receiver JDBC adapter.

Check this link for that,

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

Check the part for STATEMENTNAME6 and also the example for that in the same link,

Regards,

Bhavesh