Retrieve the records b/w 20th and 30th Rows

SINDHU · New User Joined: 22 Apr 2005 Posts: 2 Location: CHENNAI

HI,
I would like to know how to retrieve the records b/w 20th and 30th rows.

Regards
sindhu

eswar · New User Joined: 19 Feb 2005 Posts: 5 Location: chennai

Hi,

U can do it Using FIle-Aid tool, And in that ,Use the Option
Selection Criteria.

Reards,

eswar

notonly4u · New User Joined: 26 Apr 2005 Posts: 87 Location: Hyderabad

Dear Sindhu,

You can do a sort by

OPtion Copy

Skiprec=20
Stopaft=10

This will get yu the recs b/w 20 and 30.

Hope iam Right

Regards

priyesh.agrawal · Posted: Fri Apr 29, 2005 4:00 pm

Oh, really were you asking for a Flat Data Set.

I thought it shouldn't be a bycycle if you are asking for a JACK.

Regards,

Priyesh

Ram_k · New User Joined: 28 Apr 2005 Posts: 5 Location: Chennai

Hi,

If u want to retrieve records btw 20 and 30th rows..u can use scrollable cursors (Db2v7) where u can do positioned select..pls refer to SQL refv7.1 for the syntax

ovreddy · Posted: Wed May 04, 2005 2:05 pm

Hi Sindhu,

Use scrollable cursors as suggested by Ram. Then use the following syntax to fetch rows b/w 20 and 30.

FETCH ROWSET STARTING AT ABSOLUTE 20
FROM CURS1 FOR 10 ROWS
INTO :hav1, :hva2, :hva3;

hav1,hav2 and hav3 are hostvariable arrays.

Thanks,
Reddy.