sorting with omit



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

sorting with omit

Postby blackswan » Thu Dec 06, 2012 6:33 pm

Hi,

I have a PS file with records with LRECL=80:

ABCDE 98789
ABCDE 456789087
ABCDE 5647860
ABCDE 89568
ABCDE 1


The output PS will contain with LRECL=80:

98789
456789087
5647860
89568
1


How can I do this by sort utility?

regards
utpal
blackswan
 
Posts: 13
Joined: Thu Sep 13, 2012 2:39 pm
Has thanked: 0 time
Been thanked: 1 time

Re: sorting with omit

 

Re: sorting with omit

Postby blackswan » Thu Dec 06, 2012 6:36 pm

I tried with:

SORT FIELDS=COPY
OMIT=(1,5,CH,EQ,C'ABCDE')


But I am getting blank in 2nd file.
blackswan
 
Posts: 13
Joined: Thu Sep 13, 2012 2:39 pm
Has thanked: 0 time
Been thanked: 1 time

Re: sorting with omit

Postby BillyBoyo » Thu Dec 06, 2012 6:45 pm

OMIT or INCLUDE is how you "filter" records from the input file.

Try

  INREC BUILD=(6,75)


on the line following your COPY and drop the OMIT.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: sorting with omit

Postby blackswan » Fri Dec 07, 2012 1:14 pm

Thanks Billy :)
blackswan
 
Posts: 13
Joined: Thu Sep 13, 2012 2:39 pm
Has thanked: 0 time
Been thanked: 1 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post