I did use EQUALS in SORT but still the OMIT SAVE file is empty
SYNCSORT FOR Z/OS 1.2.3.0R U.S. PATENTS: 4210961, 5117495 (C) 2005 SYNCSO
z/OS 1.7.0
PRODUCT LICENSED FOR CPU SERIAL NUMBER 9798D, MODEL 2084 309 LICEN
SYSIN :
SORT FIELDS=(133,5,CH,A,138,3,CH,A,141,3,CH,A),EQUALS
OUTFIL FNAMES=SORTFL1
OMIT COND=((133,5,CH,EQ,C'H6717'),OR,(133,5,CH,EQ,C'H7254'),OR,
(133,5,CH,EQ,C'H9016'),OR,(133,5,CH,EQ,C'H9418'),OR,
(133,11,CH,EQ,C'H2320004001'),OR,
(133,11,CH,EQ,C'H2320004002'),OR,
(133,11,CH,EQ,C'H2320004003'),OR,
(133,11,CH,EQ,C'H2320005001'),OR,
(133,11,CH,EQ,C'H2320005002'),OR,
(133,11,CH,EQ,C'H2320005003'),OR,
(133,11,CH,EQ,C'H5849001001'),OR,
(133,11,CH,EQ,C'H5849001002'),OR,
(133,11,CH,EQ,C'H5849001003'))
OUTFIL FNAMES=SORTFL2,SAVE
WER108I SORTIN : RECFM=FB ; LRECL= 466; BLKSIZE= 27960
WER110I SORTFL1 : RECFM=FB ; LRECL= 466; BLKSIZE= 27960
WER110I SORTFL2 : RECFM=FB ; LRECL= 466; BLKSIZE= 27960
WER045C END SORT PHASE
WER055I INSERT 0, DELETE 1157
WER418I DATASPACE(S) AND/OR HIPERSPACE(S) USED
WER405I SORTFL1 : DATA RECORDS OUT 2604122; TOTAL RECORDS OUT 2604122
WER405I SORTFL2 : DATA RECORDS OUT 0; TOTAL RECORDS OUT 0
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE
WER246I FILESIZE 1,213,520,852 BYTES
WER054I RCD IN 2605279, OUT 2604122
WER072I EQUALS IN EFFECT
WER169I RELEASE 1.2 BATCH 0454 TPF LEVEL 3.0
WER052I END SYNCSORT - M3CQSOT1,STEP1,,DIAG=9D00,DB1F,A010,E07D,C5FE,6883,2748
******************************* Bottom of Data ********************************
Also I tried to take out COND from OMIT it throws Snytax error. Is there any version problem here.
z/OS 1.7.0
PRODUCT LICENSED FOR CPU SERIAL NUMBER 9798D, MODEL 2084 309 L
SYSIN :
SORT FIELDS=(133,5,CH,A,138,3,CH,A,141,3,CH,A),EQUALS
OUTFIL FNAMES=SORTFL1
OMIT=((133,5,CH,EQ,C'H6717'),OR,(133,5,CH,EQ,C'H7254'),OR,
*
(133,5,CH,EQ,C'H9016'),OR,(133,5,CH,EQ,C'H9418'),OR,
*
(133,11,CH,EQ,C'H2320004001'),OR,
*
(133,11,CH,EQ,C'H2320004002'),OR,
*
(133,11,CH,EQ,C'H2320004003'),OR,
*
(133,11,CH,EQ,C'H2320005001'),OR,
*
(133,11,CH,EQ,C'H2320005002'),OR,
*
(133,11,CH,EQ,C'H2320005003'),OR,
*
(133,11,CH,EQ,C'H5849001001'),OR,
*
(133,11,CH,EQ,C'H5849001002'),OR,
*
(133,11,CH,EQ,C'H5849001003'))
*
OUTFIL FNAMES=SORTFL2,SAVE
WER268A OMIT STATEMENT : SYNTAX ERROR
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
MSTP wrote:
Hooray it worked.
But do you know why?
Alissa Margulies, SyncSort Mainframe Support wrote:
The application is working exactly as it was coded. The problem is the understanding of the control statements. OMIT COND= is executed in Phase 1. It is not part of OUTFIL processing. This is why the SAVE parameter appeared not to have captured any records. All records remaining after the OMIT processing went to the first outfil group, leaving none for the SAVE. (If a comma was simply added, you would have gotten a syntax error).
OUTFIL OMIT= is part of OUTFIL processing and it executes in Phase 3 of the sort. (Please refer to Chapter 8 in the SyncSort for z/OS Programmer's Guide for additional information regarding the Flow of the Sort). I hope this helps to clarify it a little.
.jpg)
