Skip to Content
0
Former Member
May 14, 2008 at 03:13 PM

jdbc adatper - sender adapter

20 Views

hi i am using a jdbc adapter to connect to the sql database. in the jdbc sender adapter under the :

Query SQL statement field, I use --> SELECT TOP 100 * FROM TABLENAME WHERE FLAG = 'UNPROCESSED'

Update SQL Statement field, I use --> UPDATE TABLENAME SET FLAG = 'PROCESSED' WHERE FLAG = 'UNPROCESSED'.

there are 1000 records in the table. the above update statement updates the flag as 'processed' for all the 1000 records in the table.

what i want to achieve is that when i query 100 unprocessed records from the table, i want to update the flag as 'processed' only to those 100 records. in that case, what should my update SQL statement look like.

please explain.

thanks.

krish