_______________________________________________________________
This message and any attachments are intended for the individual or entity
named above. If you are not the intended recipient, please do not read,
copy, use or disclose this communication to others; also please notify the
sender by replying to this message, and then delete it from your system.
Thank you.
_______________________________________________________________
As far as I can tell, (and I'm sure the others will correct me if I'm
wrong) the only way to do that in the version you're using is with a cursor
in 4gl or esql. If you're using either one of those, check out the FETCH
commands.
vtnguyen <vtnguyen@home.com> on 05/01/2000 10:38:31 PM
Extension:
To: informix-list@iiug.org
cc: (bcc: Colleen M. Morrow/JonesDay)
Subject: Want to get the first n records
Hi there,
I would like to get only the first 100 records from the result set of
the query.
How do I do that? (I am using IDS 7.23.).
Thanks
Tung Nguyen