Page 1 of 1

DFSORT - please help

PostPosted: Tue Sep 15, 2009 3:44 pm
by kothai
My code is

  OUTFIL FILES=6,                                               
    OUTREC=(24,99),                                       
    INCLUDE=(4,6,CH,EQ,C'RAM1234 ',AND,                   
       (46,2,CH,NE,C'A1',AND,46,2,CH,NE,C'B1)),


This code worked like
1. Including records of only 'RAM1234'
2. Omiting those records which have A1 or B1 in 46th position

Now the requirement is to omit only records A1 which has 'IMP' in postion 20. the rest needs to be included.. how to do this . please help

Re: DFSORT - please help

PostPosted: Tue Sep 15, 2009 6:40 pm
by ravisankarc
Hi,

Include=(20,3,CH,EQ,C'IMP')

Re: DFSORT - please help

PostPosted: Tue Sep 15, 2009 8:57 pm
by Frank Yaeger
the requirement is to omit only records A1 which has 'IMP' in postion 20. the rest needs to be included.


   OMIT=(46,2,CH,EQ,C'A1',AND,20,3,CH,EQ,C'IMP')