In a stored procedure I need to update 100 rows in a file with a batch number if the batch number is currently 0. It doesn't look like having "fetch 100 rows only" is valid on an UPDATE statement, so is there another way that I can accomplish the same thing?
Here's what my statement currently looks like:
SET ehbtch = v_batch_number
where ehbtch = 0
FETCH first 100 rows only;
Any suggestions would be greatly appreciated!