What happens if you code the include like this? OUTFIL INCLUDE=(19,1,CH,EQ,C'ABCDEFGHIJKLNOPQRSTUVWXYZ0123456789')
Joe On Thu, Aug 20, 2020 at 6:27 AM John McKown <[email protected]> wrote: > This is on z/OS 1.12 (sorry). A programmer has run two DFSORT jobs with > slightly different control statements which both of us think should result > in the same output. But it does not. One uses the OMIT statement. The other > uses an OUTFIL with a COND. Both use SUM FIELDS=NONE and EQUALS=YES to > remove all duplicate keys, keeping the first record. But the output is > different. The OMIT run has more records. A quick look seems to indicate > that OMIT is what he really wants. Here are the DFSOFT messages. I just > can't see why the OMIT has more output. Most likely due to my own lack of > understanding. > > === OMIT === > > 1ICE201I H RECORD TYPE IS V - DATA STARTS IN POSITION 5 > > ICE751I 0 C5-K62149 C6-K90026 C7-K58148 C8-K67572 E9-K60824 C9-BASE > E5-K70685 E6-K58148 C4-K58148 E7-K70685 > ICE143I 0 BLOCKSET SORT TECHNIQUE SELECTED > > ICE250I 0 VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPERS, > EXAMPLES AND MORE > ICE000I 1 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R12 - 13:41 ON > WED AUG 19, 2020 - > 0 SORT FIELDS=(13,16,CH,A),EQUALS > 00190001 > SUM FIELDS=NONE > 00200001 > OMIT COND=(191,1,CH,EQ,C'M') DROP M* POLICIES > 00210001 > ICE201I H RECORD TYPE IS V - DATA STARTS IN POSITION 5 > > ICE751I 0 C5-K62149 C6-K90026 C7-K58148 C8-K67572 E9-K60824 C9-BASE > E5-K70685 E6-K58148 C4-K58148 E7-K70685 > ICE193I 0 ICEAM1 INVOCATION ENVIRONMENT IN EFFECT - ICEAM1 ENVIRONMENT > SELECTED > ICE088I 0 APH893GI.PS050 . , INPUT LRECL = 12285, BLKSIZE = > 27998, TYPE = VB > ICE093I 0 MAIN STORAGE = (MAX,38877188,38877188) > > ICE156I 0 MAIN STORAGE ABOVE 16MB = (38819828,38819828) > > ICE127I 0 OPTIONS: OVFLO=RC0 ,PAD=RC0 ,TRUNC=RC0 > ,SPANINC=RC16,VLSCMP=N,SZERO=Y,RESET=Y,VSAMEMT=Y,DYNSPC=256 > ICE128I 0 OPTIONS: > SIZE=38877188,MAXLIM=1048576,MINLIM=450560,EQUALS=Y,LIST=Y,ERET=RC16 > ,MSGDDN=SYSOUT > ICE129I 0 OPTIONS: VIO=N,RESDNT=ALL ,SMF=NO > ,WRKSEC=Y,OUTSEC=Y,VERIFY=N,CHALT=N,DYNALOC=(SYSDA ,031),ABCODE=MSG > ICE130I 0 OPTIONS: RESALL=4096,RESINV=0,SVC=109 > ,CHECK=Y,WRKREL=Y,OUTREL=Y,CKPT=N,COBEXIT=COB2 > ICE131I 0 OPTIONS: > TMAXLIM=6291456,ARESALL=0,ARESINV=0,OVERRGN=65536,CINV=Y,CFW=Y,DSA=64 > > ICE132I 0 OPTIONS: VLSHRT=N,ZDPRINT=Y,IEXIT=N,TEXIT=N,LISTX=N,EFS=NONE > ,EXITCK=S,PARMDDN=DFSPARM ,FSZEST=N > ICE133I 0 OPTIONS: HIPRMAX=OPTIMAL,DSPSIZE=MAX > ,ODMAXBF=0,SOLRF=Y,VLLONG=N,VSAMIO=N,MOSIZE=0 > ICE235I 0 OPTIONS: NULLOUT=RC0 > > ICE236I 0 OPTIONS: DYNAPCT=10 ,MOWRK=Y > > ICE084I 0 EXCP ACCESS METHOD USED FOR SORTOUT > > ICE084I 0 EXCP ACCESS METHOD USED FOR SORTIN > > ICE750I 0 DC 10419394794 TC 0 CS DSVUU KSZ 20 VSZ 20 > > ICE752I 0 FSZ=10419394794 BC IGN=0 E AVG=6143 0 WSP=13535205 C > DYN=244621 56664 > ICE751I 1 D8-K58148 D4-K59452 EA-K59517 F1-K58148 E8-K70685 > > ICE090I 0 OUTPUT LRECL = 12285, BLKSIZE = 27998, TYPE = VB > > ICE055I 0 INSERT 0, DELETE 1068329 > > ICE054I 0 RECORDS - IN: 6258994, OUT: 5190665 > > ICE134I 0 NUMBER OF BYTES SORTED: 7993209593 > > ICE253I 0 RECORDS SORTED - PROCESSED: 5215434, EXPECTED: 1696417 > > ICE098I 0 AVERAGE RECORD LENGTH - PROCESSED: 1532, EXPECTED: 6142 > > ICE165I 0 TOTAL WORK DATA SET TRACKS ALLOCATED: 245055 , TRACKS USED: > 145365 > ICE199I 0 MEMORY OBJECT USED AS MAIN STORAGE = 0M BYTES > > ICE299I 0 MEMORY OBJECT USED AS WORK STORAGE = 0M BYTES > > ICE180I 0 HIPERSPACE STORAGE USED = 0K BYTES > > ICE188I 0 DATA SPACE STORAGE USED = 0K BYTES > > ICE052I 0 END OF DFSORT > > > === INCL === > > 1ICE201I H RECORD TYPE IS V - DATA STARTS IN POSITION 5 > > ICE751I 0 C5-K62149 C6-K90026 C7-K58148 C8-K67572 E9-K60824 C9-BASE > E5-K70685 E6-K58148 C4-K58148 E7-K70685 > ICE143I 0 BLOCKSET SORT TECHNIQUE SELECTED > > ICE250I 0 VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPERS, > EXAMPLES AND MORE > ICE000I 1 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R12 - 13:54 ON > WED AUG 19, 2020 - > 0 SORT FIELDS=(13,16,CH,A),EQUALS > 00190001 > SUM FIELDS=NONE > 00200001 > OUTFIL INCLUDE=(191,1,CH,NE,C'M') DROP M* POLICIES > 00210001 > ICE201I H RECORD TYPE IS V - DATA STARTS IN POSITION 5 > > ICE751I 0 C5-K62149 C6-K90026 C7-K58148 C8-K67572 E9-K60824 C9-BASE > E5-K70685 E6-K58148 C4-K58148 E7-K70685 > ICE193I 0 ICEAM1 INVOCATION ENVIRONMENT IN EFFECT - ICEAM1 ENVIRONMENT > SELECTED > ICE088I 0 APH893GI.PS050 . , INPUT LRECL = 12285, BLKSIZE = > 27998, TYPE = VB > ICE093I 0 MAIN STORAGE = (MAX,38877188,38877188) > > ICE156I 0 MAIN STORAGE ABOVE 16MB = (38815751,38815751) > > ICE127I 0 OPTIONS: OVFLO=RC0 ,PAD=RC0 ,TRUNC=RC0 > ,SPANINC=RC16,VLSCMP=N,SZERO=Y,RESET=Y,VSAMEMT=Y,DYNSPC=256 > ICE128I 0 OPTIONS: > SIZE=38877188,MAXLIM=1048576,MINLIM=450560,EQUALS=Y,LIST=Y,ERET=RC16 > ,MSGDDN=SYSOUT > ICE129I 0 OPTIONS: VIO=N,RESDNT=ALL ,SMF=NO > ,WRKSEC=Y,OUTSEC=Y,VERIFY=N,CHALT=N,DYNALOC=(SYSDA ,031),ABCODE=MSG > ICE130I 0 OPTIONS: RESALL=4096,RESINV=0,SVC=109 > ,CHECK=Y,WRKREL=Y,OUTREL=Y,CKPT=N,COBEXIT=COB2 > ICE131I 0 OPTIONS: > TMAXLIM=6291456,ARESALL=0,ARESINV=0,OVERRGN=65536,CINV=Y,CFW=Y,DSA=64 > > ICE132I 0 OPTIONS: VLSHRT=N,ZDPRINT=Y,IEXIT=N,TEXIT=N,LISTX=N,EFS=NONE > ,EXITCK=S,PARMDDN=DFSPARM ,FSZEST=N > ICE133I 0 OPTIONS: HIPRMAX=OPTIMAL,DSPSIZE=MAX > ,ODMAXBF=2097152,SOLRF=Y,VLLONG=N,VSAMIO=N,MOSIZE=0 > ICE235I 0 OPTIONS: NULLOUT=RC0 > > ICE236I 0 OPTIONS: DYNAPCT=10 ,MOWRK=Y > > ICE084I 0 EXCP ACCESS METHOD USED FOR SORTIN > > ICE750I 0 DC 10419394794 TC 0 CS DSVUU KSZ 20 VSZ 20 > > ICE752I 0 FSZ=10419394794 BC IGN=0 E AVG=6143 0 WSP=13535205 C > DYN=244621 56664 > ICE231I 0 STORAGE USED FOR OUTFIL : BELOW 16M = 20480, ABOVE 16M = 2127872 > > ICE210I 0 SORTOUT : EXCP USED, LRECL = 12285, BLKSIZE = 27998, TYPE = VB > > ICE751I 1 D8-K58148 D4-K59452 EA-K59517 CB-K64632 F1-K58148 E8-K70685 > > ICE055I 0 INSERT 0, DELETE 25000 > > ICE054I 0 RECORDS - IN: 6258994, OUT: 6233994 > > ICE227I 0 SORTOUT : DELETED = 1043560, REPORT = 0, DATA = 5190434 > > ICE228I 0 SORTOUT : TOTAL IN = 6233994, TOTAL OUT = 5190434 > > ICE134I 0 NUMBER OF BYTES SORTED: 9242949758 > > ICE253I 0 RECORDS SORTED - PROCESSED: 6258994, EXPECTED: 1696417 > > ICE098I 0 AVERAGE RECORD LENGTH - PROCESSED: 1476, EXPECTED: 6142 > > ICE165I 0 TOTAL WORK DATA SET TRACKS ALLOCATED: 245055 , TRACKS USED: > 165420 > ICE199I 0 MEMORY OBJECT USED AS MAIN STORAGE = 0M BYTES > > ICE299I 0 MEMORY OBJECT USED AS WORK STORAGE = 0M BYTES > > ICE180I 0 HIPERSPACE STORAGE USED = 0K BYTES > > ICE188I 0 DATA SPACE STORAGE USED = 0K BYTES > > ICE052I 0 END OF DFSORT > > > =========== > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
