by Can some informix "guru" tell me the equivalent command of 'set rowcount n' SQL command of
sybase.
for eg. in sybase SQL command, I can limit the number of rows processed by server by this command
-
isql
1> set rowcount 3
2>go
1> select * from customer
2>go
this returns just 2 rows.
That is, I can tell the database server to STOP processing after first 2 rows, as I will be
interested only first 2 rows in the app
al