Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
INCLUDE condition in SYNCSORT
Goto page Previous  1, 2
 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
MSTP

New User


Joined: 21 Jun 2007
Posts: 30
Location: Baltimore

PostPosted: Tue Oct 16, 2007 1:50 am    Post subject:
Reply with quote

Hi

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
Back to top
View user's profile Send private message

annujp

New User


Joined: 31 Aug 2005
Posts: 39
Location: St Paul,MN

PostPosted: Tue Oct 16, 2007 1:54 am    Post subject:
Reply with quote

Can you put a ',' after the FNAMES=SORTFL1 and write 'OMIT=' ?
Code:
OUTFIL FNAMES=SORTF1,OMIT=(27,4,CH,EQ,C'PULI')
Back to top
View user's profile Send private message
annujp

New User


Joined: 31 Aug 2005
Posts: 39
Location: St Paul,MN

PostPosted: Tue Oct 16, 2007 2:01 am    Post subject:
Reply with quote

Try this as ur SORT card

Code:
 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
Back to top
View user's profile Send private message
MSTP

New User


Joined: 21 Jun 2007
Posts: 30
Location: Baltimore

PostPosted: Tue Oct 16, 2007 2:05 am    Post subject:
Reply with quote

Hooray it worked.Thanks Anitha.

Prasad
Back to top
View user's profile Send private message
annujp

New User


Joined: 31 Aug 2005
Posts: 39
Location: St Paul,MN

PostPosted: Tue Oct 16, 2007 2:05 am    Post subject:
Reply with quote

You are welcome icon_biggrin.gif
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Wed Oct 17, 2007 4:51 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Goto page Previous  1, 2
Page 2 of 2

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts LRECL in syncsort frozenblood87 SYNCSORT 4 Tue Feb 19, 2019 6:50 am
No new posts SYNCSORT keep MIN/MAX record Cloink SYNCSORT 16 Mon Sep 17, 2018 3:00 pm
No new posts Add STAT condition Balu5491 Compuware & Other Tools 1 Mon Jul 30, 2018 7:32 pm
No new posts Comparing Comp-3 fields with greater ... Prateeksichem1 DFSORT/ICETOOL 11 Fri Jul 13, 2018 8:45 am
No new posts Remove duplicate record with condition rajiv rengasamy DFSORT/ICETOOL 4 Wed Jul 11, 2018 3:55 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us