I'm not working with any PL programs nor stored procedures, etc. In a simple query that I execute via ODBC from a client program I can't use any fetch (am I mistaken?). In other words, the sintax of a Select statement don't allow to restrict the number of returned rows.
Thanks a lot for your help.
I think your first response is the correct one:
Select * from your_table fetch first 10 rows only
But this sintax is only allowed at the last IBM version (5.1) and is not my case.
Thanks for your help