What I want is I want to write only 10 records of the combination ABC01 and 10 records of the combination ABC02 to an output
file,I want only 15 records of PQR01 and in a similar way others also ,how can i do this , please help.
I have my records in the file of this fashion and they are sorted in 1-10 columns as well as by company which is col 12 - 14
already.
Code:
----+----1----+----2----+----3----+----4----+----5----+
********************************* Top of Data *********
1190000000|11|SPP|SPECIAL-PRODUCT |FPAVL|
1190000010|11|SPP|SPECIAL-PRODUCT |FPAVL|
1190000030|11|SPP|SPECIAL-PRODUCT |FPAVL|
1190000040|11|SPP|SPECIAL-PRODUCT |FPAVL|
1190000050|11|SPP|SPECIAL-PRODUCT |FPAVL|
1190000070|11|SPP|SPECIAL-PRODUCT |FPAVL|
1190000100|11|SPP|SPECIAL-PRODUCT |FPAVL|
1190000120|11|SPP|SPECIAL-PRODUCT |FPAVL|
1190000130|11|SPP|SPECIAL-PRODUCT |FPAVL|
1190000160|11|SPP|SPECIAL-PRODUCT |FPAVL|
1190000220|11|SPP|SPECIAL-PRODUCT |FPAVL|
1190000280|11|SPP|SPECIAL-PRODUCT |FPAVL|
1190000360|11|SPP|SPECIAL-PRODUCT |FPAVL|
1190000400|11|SPP|SPECIAL-PRODUCT |FPAVL|
1190000430|11|SPP|SPECIAL-PRODUCT |FPAVL|
1190000470|11|OPT|OPTIONS PLUS |OPTPL|
1190000500|11|OPT|OPTIONS PLUS |OPTPL|
.
.
.
.
.
.
I want to select only 15 records of either FPAVL,FPAVU OR FPAVQ as these could be the possible values in col 50 - 54
I want to select only 10 records of either OPTPL,OPRM1 with 11 as the company which is in col 12 - 13
I want to select only 10 records of either OPTPL,OPRM1 with 13 as the company which is in col 12 - 13
I want to select only 15 records of either SOELR as these could be the possible value in col 50 - 54
.
.
and some other conditons.
If i am able to get the desired count , i can write the code further and below is what i am trying: Input dataset LRECL=104
Joined: 26 Nov 2002 Posts: 12376 Topics: 75 Location: San Jose
Posted: Fri Mar 06, 2009 6:36 pm Post subject:
yadav2005,
I'm a DFSORT developer. DFSORT and Syncsort are competitive products. I'm happy to answer questions on DFSORT and DFSORT's ICETOOL, but I don't answer questions on Syncsort.
Chandra,
Even if OP changes the length to 8 bytes he will NOT get the desired results. He is just using a seqnum and it will never get him the desired results. He needs to validate 2 fields _________________ Kolusu
www.linkedin.com/in/kolusu
Note that I added back in the RESTART that kolusu originally suggested, and changed the CH FORMAT to SS from the code you last supplied. I have only tested this with a minimal number of records, so you will need to do further testing using your data.
Hope this helps! Please feel free to contact me directly at zos_tech@syncsort.com if you require further assistance. _________________ Brian Wood
SyncSort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum