Update sentence in JDBC SENDER

[Former Member]

Hi mates,

I have a doubt about a sentence update in JDBC SENDER adater.

This update we apply, is from all the Database or from de Select we do??

Thanks a lot

[Former Member · Accepted solution]

You can use "serializable" option in advanced mode to update exactly same records which are picked by select query.

Warm Regards,

Gouri

[Former Member]

Hi,

The databasename is specified in the connection string. The update statement will have scope of only this database.

Ideally the update statement should have the same where conditions as the select statement, so that exactly the same records are updated which are selected.

To be doubly sure of the sync between select and update statements check the DB issolation level parameter in JDBC sender adapter.

Hope this helps.

Regards,

Siddhesh S.Tawate

[rajasekhar_reddy14]

Hi Find the below link,

http://help.sap.com/saphelp_nwpi71/helpdata/EN/7e/5df96381ec72468a00815dd80f8b63/content.htm

Regards,

Raj

[Former Member]

The update is like a normal statement how we execute in the SQL ...

that is whatever the update statement you provide in the sender adapter the same will be executed in the respective database tables

HTH

Rajesh