DFSORT - please help



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

DFSORT - please help

Postby kothai » Tue Sep 15, 2009 3:44 pm

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
kothai
 
Posts: 6
Joined: Fri Aug 28, 2009 1:07 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DFSORT - please help

 

Re: DFSORT - please help

Postby ravisankarc » Tue Sep 15, 2009 6:40 pm

Hi,

Include=(20,3,CH,EQ,C'IMP')
ravisankarc
 
Posts: 47
Joined: Thu Aug 27, 2009 2:18 am
Has thanked: 0 time
Been thanked: 0 time

Re: DFSORT - please help

Postby Frank Yaeger » Tue Sep 15, 2009 8:57 pm

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')
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post