Very Computer

I have a customer who is interested in running our ODBC-based application
on Informix. The application was originally targeted for SQL Server, and
uses the SQL Server specific feaure "SET ROWCOUNT n" to cap the number of
rows returned or processed by a query in some situations.

Does Informix support a comparable feature?

--
Randy Baker (remove Z from address in email replies)

Quote:> I have a customer who is interested in running our ODBC-based
> application on Informix. The application was originally targeted for
> SQL Server, and uses the SQL Server specific feaure "SET ROWCOUNT n"
> to cap the number of rows returned or processed by a query in some
> situations.

> Does Informix support a comparable feature?

--
Ciao,
Billy

Nose to the ear in Johannesburg -- * City never looked so good!
For a good time, call: http://www.veryComputer.com/

I installed a photo of Princess Di as "wallpaper" on my PC, just as
kind of a tribute or memorial or something.  Looks nice, but every
time I try and take a screen shot, my machine crashes.

        SELECT  cols
        FROM    table
        WHERE   no_rows >    (
                                SELECT  COUNT(*)
                                FROM    same_table
                                WHERE   same_table.primary_key <
                                                table.primary_key
                                )

where no_rows is the number of rows to return.

The following returns the first ten customer numbers from the customer
table:

        SELECT  customer_num
        FROM    customer
        WHERE   10 > (
                        SELECT  COUNT(*)
                        FROM    customer c
                        WHERE   c.customer_num < customer.customer_num
                        )

Hope that helps,
--
Mark.

+----------------------------------------------------------+-----------+
|Mark D. Stock - Informix SA       http://www.informix.com |////////  /|

|                      +-----------------------------------+////  / ///|
| 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.|//  / /////|

+----------------------+-----------------------------------+-----------+

Quote:>         SELECT  cols
>         FROM    table
>         WHERE   no_rows >       (
>                                 SELECT  COUNT(*)
>                                 FROM    same_table
>                                 WHERE   same_table.primary_key <
>                                                 table.primary_key
>                                 )

> where no_rows is the number of rows to return.

> The following returns the first ten customer numbers from the customer
> table:

>         SELECT  customer_num
>         FROM    customer
>         WHERE   10 >    (
>                         SELECT  COUNT(*)
>                         FROM    customer c
>                         WHERE   c.customer_num < customer.customer_num
>                         )

Art S. Kagel