Skip to Content

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

How does JDBC sender adapter reads data from DB

Hi ALL,

I have scenario where the JDBC adapter has to read the data once every month. now how would JDBC adapter know that it has to select data which has been updated after last months select only and not the old data?

XIer

Former Member
Former Member replied

Hey

in the sender JDBC adapter you give the select statement as well as update statement.

what you do is that once you select the data from data base you use an update query to set a flag to false,so that you dont select that data again next time.

have a look at this blog

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

in this he has used both select and update query on the sender side

Thanx

Aamir suhail

Message was edited by:

Aamir Suhail

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