Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

JDBC adapter - no UPDATE to database


I have the scenario ABAP Proxy to XI to JDBC to read some data from a database and return some info back to BW. Is it mandatory to UPDATE the selected records in some way or can the UPDATE part of the adapter be disabled by putting something in the UPDATE parameter on the comm channel ?



Former Member

Hi Colin,

if you are talking about a sender JDBC adapter: you can put <TEST> in the update statement.

See this snippet from the help:

<i>Update SQL Statement

You have the following options:

Enter a valid SQL statement that is to be applied to the database once the data (determined from the Query SQL Statement) has been successfully sent to the Integration Server/PCK.

It must be an INSERT, UPDATE, or DELETE statement.

In place of the SQL statement, you can also enter <TEST>. Once the data determined from Query SQL Statement has been successfully sent, the data in the database remains unaltered.

This is recommended if the data has not only been read, but also changed by a stored procedure entered under Query SQL Statement.</i>

If you want to synchronously call a receiver JDBC adapter, i think you can use action=SELECT without an update.



0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question