update sql statement in sender/receiver jdbc adapter

[Former Member]

Hi

What is the update sql statement we give in the sender/ receiver adapter when

1) SELECT statement was written in query sql statement

2) EXECUTE statement was written for a stored procedure in query sql statement

thanks

Anitha

[stefan_grube]

> 1) SELECT statement was written in query sql statement

your table should have some value "already_processed" which prevents a second processing of that table.

the update statement sets that value.

> 2) EXECUTE statement was written for a stored procedure in query sql statement

the same as above.

when your stored procedure already does the update, then write a second stored procedure which does nothing.

[Former Member]

Incase finding it difficult to find

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/frameset.htm

[former_member200962]

Did you checked the JDBC adapter section in help.sap.com ..... the formats for both Sender and receiver adapters are mentioned.

Regards,

Abhishek.