Informix

Hello All,


           How can I select Next few rows . e.g. SELECT FIRST 1000 * FROM emp ----> it will give me first 1000 record.

           But if I need next 1001 - 2000 rows , then how can I select in Informix 11.70?


      Kindly guide.


Thanks
Amit Patel

------------------------------
AMIT PATEL
------------------------------

Original Message:
Sent: 3/15/2021 9:39:00 AM
From: AMIT PATEL
Subject: select next rows

Hello All,


           How can I select Next few rows . e.g. SELECT FIRST 1000 * FROM emp ----> it will give me first 1000 record.

           But if I need next 1001 - 2000 rows , then how can I select in Informix 11.70?


      Kindly guide.


Thanks
Amit Patel

------------------------------
AMIT PATEL
------------------------------

I checked in google and found below syntax :

SELECT SKIP 1000 FIRST 1000 * FROM emp ;    ---- it will skip first start 1000 records and will show next 1000 rows;

------------------------------
AMIT PATEL
------------------------------

Original Message:
Sent: Mon March 15, 2021 09:38 AM
From: AMIT PATEL
Subject: select next rows

Hello All,


           How can I select Next few rows . e.g. SELECT FIRST 1000 * FROM emp ----> it will give me first 1000 record.

           But if I need next 1001 - 2000 rows , then how can I select in Informix 11.70?


      Kindly guide.


Thanks
Amit Patel

------------------------------
AMIT PATEL
------------------------------

As Paul hinted:

SELECT SKIP 1000 FIRST 1000 * FROM emp;

------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
------------------------------

Original Message:
Sent: Mon March 15, 2021 09:38 AM
From: AMIT PATEL
Subject: select next rows

Hello All,


           How can I select Next few rows . e.g. SELECT FIRST 1000 * FROM emp ----> it will give me first 1000 record.

           But if I need next 1001 - 2000 rows , then how can I select in Informix 11.70?


      Kindly guide.


Thanks
Amit Patel

------------------------------
AMIT PATEL
------------------------------

Original Message:
Sent: 3/15/2021 9:50:00 AM
From: Art Kagel
Subject: RE: select next rows

As Paul hinted:

SELECT SKIP 1000 FIRST 1000 * FROM emp;

------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
------------------------------

Original Message:
Sent: Mon March 15, 2021 09:38 AM
From: AMIT PATEL
Subject: select next rows

Hello All,


           How can I select Next few rows . e.g. SELECT FIRST 1000 * FROM emp ----> it will give me first 1000 record.

           But if I need next 1001 - 2000 rows , then how can I select in Informix 11.70?


      Kindly guide.


Thanks
Amit Patel

------------------------------
AMIT PATEL
------------------------------

Hi Amit,

I prefer a small SPL routine in the case to go step by step through the result set - more flexible.

Regards
Henri

------------------------------
Henri Cujass
leolo IT, CTO
Germany
------------------------------

Original Message:
Sent: Mon March 15, 2021 09:38 AM
From: AMIT PATEL
Subject: select next rows

Hello All,


           How can I select Next few rows . e.g. SELECT FIRST 1000 * FROM emp ----> it will give me first 1000 record.

           But if I need next 1001 - 2000 rows , then how can I select in Informix 11.70?


      Kindly guide.


Thanks
Amit Patel

------------------------------
AMIT PATEL
------------------------------

FWIW, in an application you can also use a CURSOR to process portions of a result set fetched without the FIRST <n> clause. Also you can use a SCROLL CURSOR to move forward and backward through a result set!

------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
------------------------------

Original Message:
Sent: Tue March 16, 2021 02:53 AM
From: Henri Cujass
Subject: select next rows

Hi Amit,

I prefer a small SPL routine in the case to go step by step through the result set - more flexible.

Regards
Henri

------------------------------
Henri Cujass
leolo IT, CTO
Germany

Original Message:
Sent: Mon March 15, 2021 09:38 AM
From: AMIT PATEL
Subject: select next rows

Hello All,


           How can I select Next few rows . e.g. SELECT FIRST 1000 * FROM emp ----> it will give me first 1000 record.

           But if I need next 1001 - 2000 rows , then how can I select in Informix 11.70?


      Kindly guide.


Thanks
Amit Patel

------------------------------
AMIT PATEL
------------------------------

Oh I see. Thank you so much for your info.

------------------------------
BK8 Indonesia
------------------------------

Original Message:
Sent: Tue March 16, 2021 08:40 AM
From: Art Kagel
Subject: select next rows

FWIW, in an application you can also use a CURSOR to process portions of a result set fetched without the FIRST <n> clause. Also you can use a SCROLL CURSOR to move forward and backward through a result set!

------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com

Original Message:
Sent: Tue March 16, 2021 02:53 AM
From: Henri Cujass
Subject: select next rows

Hi Amit,

I prefer a small SPL routine in the case to go step by step through the result set - more flexible.

Regards
Henri

------------------------------
Henri Cujass
leolo IT, CTO
Germany

Original Message:
Sent: Mon March 15, 2021 09:38 AM
From: AMIT PATEL
Subject: select next rows

Hello All,


           How can I select Next few rows . e.g. SELECT FIRST 1000 * FROM emp ----> it will give me first 1000 record.

           But if I need next 1001 - 2000 rows , then how can I select in Informix 11.70?


      Kindly guide.


Thanks
Amit Patel

------------------------------
AMIT PATEL
------------------------------