Extract n number of records from KEY value.

AJAYREDDY · New User Joined: 17 Feb 2007 Posts: 52 Location: USA

Hi,

I need to extract records from a file. I need n records from Key value. The Key starts at position 2 , 10 bytes.

For example if KEY is ABCD123456 which is 10 bytes Character, I need next 50000 records starting from this KEY. I tried with INCLUDE COND but it is no use. It only extracts 1 record in output file. I tried with OPTION STOPAFT=50000 but do not know how/where to specify the starting Key value.

Thanks

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

Is your key is in sorted order?

If so, try giving GT your key and stopaft 50000

Regards
Tanden

Escapa · Posted: Tue Dec 01, 2009 1:54 pm

Assuming your input dataset LRECL is 80
Below is sortstep to give desired result.

Frank Yaeger · Posted: Tue Dec 01, 2009 9:48 pm

Sambhaji,

Note that you are also assuming that there is only one ABCD123456 record in the file. Because a second ABCD123456 record would start a new group with a sequence number of 1, e.g.

ABCD123456 1
ABCD123457 2
ABCD123458 3
ABCD123456 1 <- seqnum starts at 1 again

If there is only one ABCD123456 record, then this would be simpler: