On Thu, Aug 20, 2020 at 7:03 AM Joe Monk <[email protected]> wrote:
> What happens if you code the include like this? > > OUTFIL INCLUDE=(19,1,CH,EQ,C'ABCDEFGHIJKLNOPQRSTUVWXYZ0123456789') > Hum, I don't know why that would be any different, but I might try it if I get desperate enough. > > 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 > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
