Solution required...

ajitkumar · New User Joined: 03 Feb 2006 Posts: 1 Location: Chennai

Hi,

could anyone please resolve the problem as mentioned under :

I have millions of record in a table, but just want to skip first 29 records and then fetch only 30 records.

pa1chandak · Active User Joined: 31 Jan 2006 Posts: 55

use

skiprec(29)
and stopafter(30)

pawan

umeshkmrsh · Active User Joined: 21 Sep 2005 Posts: 81 Location: India

See as the data in a DB2 table is considered unordered if you are not using an ORDER BY clause.

In case you are using one
(1) One way is to use cursor and skip the first 29 rec and then process next 30 records.

(2) Or you can try this link

http://forums.devshed.com/db2-development-114/row-offset-and-fetch-first-rows-157033.html

Regards,
Umesh