vineetjoshi01
New User
Joined: 06 Nov 2009
Posts: 14
Location: Singapore
|
|
|
|
I'm trying to filter out some records from a PS based on some conditions. I have written a sort card for that but I also want to have the filtered out records in a separate file. I am not able to get all the filtered out triggers in my second file.
| Code: |
SORT FIELDS=(39,10,CH,A,61,02,CH,A,71,10,CH,A,81,6,CH,A)
OUTFIL FNAMES=OUT1,INCLUDE=((39,4,CH,EQ,C'PACU'),AND,
(27,2,CH,EQ,C'EQ'),AND,
(61,2,CH,EQ,C'OG',OR,61,2,CH,EQ,C'IG',OR,
61,2,CH,EQ,C'SL',OR,61,2,CH,EQ,C'TL',OR,
61,2,CH,EQ,C'SD',OR,61,2,CH,EQ,C'TD',OR,
61,2,CH,EQ,C'OS',OR,61,2,CH,EQ,C'BS'))
OUTFIL SAVE,FNAMES=OUT2
SUM FIELDS=NONE
|
I'm trying to get all the filtered out records in OUT2.
Thanks,
Vineet |
|
