Page 1 of 1

INCLUDE and OMIT COND together

PostPosted: Thu Aug 02, 2007 5:00 pm
by amitava
Hi,
In my JCL, I want to sort my input file in some specified condition and also include and omit some conditions. My SYSIN card looks like -

//SYSIN    DD    *                                                     
 SORT FIELDS=COPY                                                     
 INCLUDE COND=(56,4,CH,EQ,C'BDS1')                                     
 OMIT COND=(1,4,CH,EQ,C'USER',OR,1,7,CH,EQ,C'SYSPGRP',OR,             
            1,13,CH,EQ,C'MHP051/MHR038',OR,1,13,CH,EQ,C'SUBSCRIBER ID',
            OR,1,15,CH,EQ,C' ',OR,42,8,CH,NE,C' ')                     
/*                                                                     


But I am getting the following error -

SYSIN :
 SORT FIELDS=COPY                                                     
 INCLUDE COND=(56,4,CH,EQ,C'BDS1')                                     
 OMIT COND=(1,4,CH,EQ,C'USER',OR,1,7,CH,EQ,C'SYSPGRP',OR,             
 *                                                                     
            1,13,CH,EQ,C'MHP051/MHR038',OR,1,13,CH,EQ,C'SUBSCRIBER ID',
            OR,1,15,CH,EQ,C' ',OR,42,8,CH,NE,C' ')                     
WER269A  INCLUDE STATEMENT : DUPLICATE STATEMENT FOUND                 
WER211B  SYNCSMF  CALLED BY SYNCSORT; RC=0000                         


Please tell me what to do? I don;t want to incorporate two steps to do the same. I want to do it in one step and if yes, then how?

Re: INCLUDE n OMIT COND together

PostPosted: Thu Aug 02, 2007 5:09 pm
by William Thompson
Wouldn't you define an include equal to be the same as an omit not equal?
Something like:
 OMIT COND=(56,4,CH,NE,C'BDS1', AND
            (1,4,CH,EQ,C'USER',OR,1,7,CH,EQ,C'SYSPGRP',OR,             
            1,13,CH,EQ,C'MHP051/MHR038',OR,1,13,CH,EQ,C'SUBSCRIBER ID',
            OR,1,15,CH,EQ,C' ',OR,42,8,CH,NE,C' ')                     
          )

Re: INCLUDE n OMIT COND together

PostPosted: Thu Aug 02, 2007 5:15 pm
by amitava
So William,
Thats mean we ca not use INCLUDE and OMIT COND together in a SORT step? I am asking!

Re: INCLUDE n OMIT COND together

PostPosted: Thu Aug 02, 2007 5:27 pm
by CICS Guy
amitava wrote:Thats mean we ca not use INCLUDE and OMIT COND together in a SORT step?
A first hint was:
WER269A INCLUDE STATEMENT : DUPLICATE STATEMENT FOUND
and a quick trip to the manual summed it up:
Only one INCLUDE/OMIT control statement can be specified for an application, either as an INCLUDE or as an OMIT control statement.