JDBC sender adapter, ...Processing parameters, Update SQL statement

[Former Member]

in JDBC sender adapter, ...Processing parameters, there is an Update SQL statement field, can u tell me ...why this is required,,,,,and in one of the example scenario...it was given as <TEST>..

[Former Member]

Hi,

asexplained above and refered the below link already see it exactly what you are looking for.

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

Regards

Chilla

[Former Member]

hi sudeep,

the update statement is used so that the row once selected is not selected again....otherwise the sql statement will be repeating itselt resulting in an infinite loop.....

Anuradha

[Former Member]

Sudeep,

You will have a select query in communication channel. What will happen at every polling interval? The same data will be selected again and again during each polling interval. To prevent this, we can have a status field which can be updated using the Update SQL statement.

<TEST> can be given in the Update SQL parameter for testing purpose. This will not update any value in the table.

For more, read help.sap.com

Regards,

Jai Shankar

[bhavesh_kantilal]

Sudheep,

In the sender JDBC adapter you have the select query to select data from the database.

Let us summer 2 cases,

1. You have <test> in the UPDATE . In this case, during every polling interval the JDBC adapter will end up selecting the same data from the Database. This would not be needed in most f the cases. Why would you want to select the same data over an over again?

2. If you have an update Statement in the Update field you can make sure that the data selected in the selected statement is updated so that the same rows are not selected again.

Take a look at this blog,

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

Regards

Bhavesh