In DB2, I need to do a
SELECT FROM UPDATE, to put an update + select in a single transaction.
But I need to make sure to update only one record per transaction.
Familiar with the
LIMIT clause from MySQL's
places a limit on the number of rows that can be updated
I looked for something similar in DB2's
UPDATE reference but without success.
How can something similar be achieved in DB2?