Re: SET ROWCOUNT
Sujit Pal wrote:
>
> Lately there has been some postings advising to SET ROWCOUNT n to get =
> the first n rows of a query, for example:
>
> SET ROWCOUNT 3;
> SELECT * FROM employee ORDER BY salary DESC;>
> will return the top 3 earners in the database.
>
> I have been trying it on my databases here but it bombs out at ROWCOUNT =
> with a 201: Syntax Error has occured. I have 7.14.UD1 and 7.20.UC2 here =
> and they are both giving me errors. What version of dbaccess / isql is =
> this supported?
It's not supported by Informix. The original post was referring to
another database I think. Certainly not Informix.
Cheers,
--
Mark.
+----------------------------------------------------------+-----------+
|Mark D. Stock - Informix SA http://www.informix.com |//////// /|
|mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //|
| +-----------------------------------+//// / ///|
| Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////|
| Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////|
|Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////|
+----------------------+-----------------------------------+-----------+