Hi GB,
> BEGIN> SELECT * FROM table1 WHERE record_id = '290202' FOR UPDATE> -- Do processing here> UPDATE table1 SET flag1 = '11' WHERE record_id = '290202'> COMMIT
This SQL is correct and will work as you expect.
Chris