IBM Mainframe Forum

Posted: **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

Posted: **Thu Oct 28, 2010 3:13 pm**

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

Posted: **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 .

Posted: **Fri Oct 29, 2010 12:28 am**

Hello,

INCLUDE the values for one output file and SAVE the others to a different output file.

Posted: **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:

Select all

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.

IBM Mainframe Forum

INCLUDE and OMIT help

INCLUDE and OMIT help

Re: INCLUDE and OMIT help

Re: INCLUDE and OMIT help

Re: INCLUDE and OMIT help

Re: INCLUDE and OMIT help