Skip to Content
Nov 27, 2012 at 06:23 PM

SELECT and UPDATE only one record for each poll interval


Dear All,

I have a issue that is related to update statement in sender jdbc adapter. My requirement is, for example I have 10 new records in table with Status=N. I have to pick only one record for each poll interval specified in communication channel. By using select statement I have fetched first record and send it to SAP. But update statement has updated all the 10 records at one time with Status=O. From next poll interval onwards, there are no records with Status=N. But I should update only one record that too is fetched by select statement. How to do this? Please let me know the solution.