INCLUDE and OMIT help



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

INCLUDE and OMIT help

Postby littlechicken » Thu Oct 28, 2010 10:23 am

help cannot determine why this is not working :)

SYNCSORT FOR Z/OS  1.3.2.1R    U.S. PATENTS: 4210961, 5117495   (C) 2007 SYNCSORT INC.   DATE=2010/301   TIME=12.40.36
                                        SYNCSORT FOR ZOS R1.3   z/OS   1.10.0                                         
SYNCSORT LICENSED FOR CPU SERIAL NUMBER xxxxxxxxxxxxxxxxxxxxxxxx             LICENSE/PRODUCT EXPIRATION DATE: 30 OCT 2010
SYSIN :                                                                                                               
  SORT FIELDS=COPY                                                      01100000                                     
       OMIT COND=((14,8,EQ,C'DSS2050E'),OR,                             01101018                                     
                  (14,8,EQ,C'DSS4050E')),FORMAT=CH                      01102018                                     
       INCLUDE COND=((2,31,EQ,C'PAGE     SV MSG.NO.    ERROR ME'),OR,   01110000                                     
       *                                                                                                             
                     (2,31,EQ,C'----     -- --------   --------'),OR,   01120000                                     
                     (22,3,EQ,C' - '),AND,                              01130000                                     
                     (11,2,GE,C' 5'),AND,                               01131013                                     
                     (14,3,EQ,C'DSS'),FORMAT=CH                         01140018                                     
WER269A  OMIT STATEMENT    : DUPLICATE STATEMENT FOUND                                                               
WER449I  SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE                                                                         


I want col 14 anything starting with "DSS" but also want to omit DSS2050E and DSS4050E as they are not needed.

any clues please I have tried the manuals etc for SYNCSORT and there is a distinct lack of more than basic simple examples :(
littlechicken
 
Posts: 25
Joined: Thu Oct 28, 2010 10:15 am
Has thanked: 0 time
Been thanked: 0 time

Re: INCLUDE and OMIT help

Postby MrSpock » Thu Oct 28, 2010 3:13 pm

You can't use both OMIT and INCLUDE together, you must use one or the other ONLY.
User avatar
MrSpock
Global moderator
 
Posts: 807
Joined: Wed Jun 06, 2007 9:37 pm
Location: Raleigh NC USA
Has thanked: 0 time
Been thanked: 4 times

Re: INCLUDE and OMIT help

Postby littlechicken » Thu Oct 28, 2010 4:12 pm

MrSpock wrote:You can't use both OMIT and INCLUDE together, you must use one or the other ONLY.


Rats so it is true.

I can make sort job fly but I cannot code it hahaha. thanks.

So how do I include and omit the fields I struggle with that all last nite .
littlechicken
 
Posts: 25
Joined: Thu Oct 28, 2010 10:15 am
Has thanked: 0 time
Been thanked: 0 time

Re: INCLUDE and OMIT help

Postby dick scherrer » Fri Oct 29, 2010 12:28 am

Hello,

INCLUDE the values for one output file and SAVE the others to a different output file.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: INCLUDE and OMIT help

Postby Alissa Margulies » Fri Oct 29, 2010 3:02 am

littlechicken wrote:So how do I include and omit the fields I struggle with that all last nite .

You should also be able to use multiple INCLUDE conditions containing a combination of EQ and NE to get the desired output.

For example:
INCLUDE COND=(2,31,EQ,C'PAGE     SV MSG.NO.    ERROR ME'),OR,                                         
             (2,31,EQ,C'----     -- --------   --------'),OR, 
             (22,3,EQ,C' - '),AND,                                                           
             (11,2,GE,C' 5'),AND,                             
             (14,3,EQ,C'DSS'),AND,
             (14,8,NE,C'DSS2050E'),AND,
             (14,8,NE,C'DSS4050E'),FORMAT=CH 

Just be sure to enclose grouped conditions in additional parenthesis depending upon what you really want in your output.
Alissa Margulies
Syncsort Mainframe Product Services
201-930-8260
zos_tech@syncsort.com
Alissa Margulies
Global moderator
 
Posts: 369
Joined: Tue Feb 26, 2008 11:15 pm
Location: USA
Has thanked: 1 time
Been thanked: 3 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post