Does the LIMIT option implemented in the SQL SELECT statement?
In order to limit the number of rows returned by the select.
In standard SQL, we have the possibility to use :
SELECT * FROM table LIMIT 10;
or
SELET TOP 10 * FROM table;
There are many different implementations of this syntax across the various DBMS. In CA Datacom the syntax is FETCH FIRST n ROWS ONLY (same as DB2). So using your example...
SELECT * FROM table FETCH FIRST n ROWS ONLY;