Re: Limiting size of SQL Result Set

Posted in 1999

Sujit.Pal@BankAmerica.com — Fri, 18 Jun 1999 09:15:55 -0700 — source: Informix-list mailing list archive (1991-1998)

Richard Try: SELECT FIRST n col1, .., coln FROM tablename HTH Sujit Richard Auslander <rich@airflash.com> on 06/17/99 04:48:28 PM Please respond to Richard Auslander <rich@airflash.com> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Limiting size of SQL Result Set We are using Dynamic Server, Version 7.30UC5, on Solaris. This version is new to me; I was told it has a new feature which enables one to specify the maximum number of rows to be returned by a SQL query, but I can't find it in our documentation. Can anyone help point me in the right direction? Many thanks! -- Richard C. Auslander Database Manager AirFlash, Inc. 1733 Woodside Rd., Suite #110 Redwood City, CA 94061 (650) 556-7928 www.airflash.com