This is a good reason to use standard SQL as much as possible, and to isolate these dependencies in stored procedures (yes, I know that this will not help you in this particular case, I just thought I mentioned this for future reference).
I suspect that you will have to change each separately, although a simple search in your source code for "select" or "first" will be a good start.
You can then decide how you want to change them, since you may also want it to work on Informix.
What is it worth, I think you get the same effect from Oracle
select * from ( select * from mytable ) where rownum <= 10
( ) , , , . , DB2 (), .
, :
gimmeRowLimitedSqlQuery ("* from test",10);
:
select first 10 * from test
select * from test where rownum <= 10
, , , SQL , order by,
select first 10 * from test
, .