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:

UPDATE cscedipoh              
SET    ehbtch = v_batch_number
where  ehbtch = 0             
FETCH  first 100 rows only;   

Any suggestions would be greatly appreciated!