Need to skip and select records consecutively using Syncsort

lagneshp · New User Joined: 15 Aug 2009 Posts: 29 Location: Chennai

Hi,

Suppose if i have 10000 records in my i/p file . i need to select only 100th, 200th, 300th ..... 10000th record.. ie.. i need to select records with are located in multiples of 100.

Please provide me code using Syncsort.

Pandora-Box · Posted: Wed Jun 20, 2012 6:42 pm

I dont have Syncsort product so cant provide exact solution

But the approach you need to follow is

1.Add sequence number at the end say at postion 81 ( Assuming your input is 80 ) having length 5
2.Select only those records having 00 or 000 or 0000 in the end

lagneshp · New User Joined: 15 Aug 2009 Posts: 29 Location: Chennai

Its Done............. using below code

SORT FIELDS=COPY
OUTREC OVERLAY=(80:SEQNUM,5,ZD)
OUTFIL INCLUDE=(81,4,ZD,EQ,0000,OR,(80,1,ZD,EQ,0,AND,82,3,ZD,EQ,000),
OR,(80,2,ZD,EQ,00,AND,83,2,ZD,EQ,00),OR,(83,2,ZD,EQ,00),OR,
(80,1,ZD,EQ,0,AND,83,2,ZD,EQ,00),OR,(82,3,ZD,EQ,000))

dbzTHEdinosauer · Posted: Wed Jun 20, 2012 7:42 pm

since you need every 100th record,
just look for the 00 as the last 2 of the 5 char sequence number,
and get rid of the rest of the garbage.

keep in mind, if you have an 80 char record, you want to overlay 81.

according to your OVERLAY statement, your records are 79 or less.

enrico-sorichetti · Posted: Wed Jun 20, 2012 8:03 pm

IIRC DFSORT has a <sample> function/capablity, verify if SYNCORT can do the same

see this topic
www.ibmmainframes.com/viewtopic.php?t=53354&highlight=dfsort+sample

and the DFSORT manual page
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ice1ca30/3.13?ACTION=MATCHES&REQUEST=sampling&TYPE=FUZZY&SHELF=ICE1SH31.bks&DT=20080528171007&CASE=&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHIT

not the latest one probably, but it describes the <sample> capability

Pandora-Box · Posted: Wed Jun 20, 2012 8:11 pm

Thanks Enrico

Very useful indeed