cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC Sender Adapter, Update statement

Former Member
0 Kudos

Hi ALL,

I have a JDBC to proxy scenario. We have stored procedure in the database that executess and sends the data to SAP.

Also the same store procedure updates the field Status_ID to distinguish between read and unread records. Status_ID acts as a Flag.

Now because the Stored procedure itself does what 'Update SQL Statement' in sender JDBC adapter does, what shall I put in 'Update SQL Statement' as it is not needed, but it's a mandatory field??

XIer

Message was edited by:

XIer

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

use <TEST> over there and see.it should be within the parenthesis i.e. exactly the way i have mentioned above

Thanx

Aamir

Message was edited by:

Aamir Suhail

ravi_raman2
Active Contributor
0 Kudos

Do you need that update in the sender jdbc adaptor to do anything....?

Dint think so..

Change your update statement to update Status_ID if its not updated..and if the sql procedure has run already then its not going to be updated ..as it already is.......

Regards

Ravi Raman