Include and Omit does not work in the same statement.
i have split my sort card into 2, 1 for include and 2 for omit.
it is working fine for the above process.
Joined: 08 May 2006 Posts: 1193 Location: Dublin, Ireland
I believe you can only have either INCLUDE or OMIT. Depending on your exact requriements, you need to specify the complete condition in the one statement e.g.
Code:
INCLUDE COND=(225,1,CH,EQ,C'X',AND,
(226,1,CH,NE,C'X',AND,
(3,3,CH,EQ,C'T08',OR,3,3,CH,EQ,C'T09',OR,
3,3,CH,EQ,C'T10',OR,3,3,CH,EQ,C'T11',OR,
3,3,CH,EQ,C'P0Y',OR,3,3,CH,EQ,C'P0Z',OR,
3,3,CH,EQ,C'P1A',OR,3,3,CH,EQ,C'P1B')))
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Quote:
My requirement is to include the records that have X in position 225 and exclude the records with (x in position 226 and T08,T09 etc in position 3).
This is an ambiguous definition for your requirement. For example, would you want to include or exclude a record that has X in position 225, X in position 226 and T08 in positions 3-5? You need to define what you want more clearly.
Note that you don't need to write all those OR conditions for the 3-5 test - you can use an SS condition like this: