Limit Number of Rows Updated in DB2 MVS

[kibord]

Good Day,

I need to limit the number of rows that an update statement affects.

Most resources on the web that i have seen suggests:

 UPDATE  (SELECT ...) SET ... WHERE ..

This seems to work fine on DB2 AIX but it does not seem to be valid with DB2 MVS and i need it to work for both.

I'm stuck with this problem for 2 days already and I am hoping someone can help me with this.

Thanks in advance.

Note: The table to be updated changes dynamically so i can't use primary keys or any specific column