SORT utility



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

SORT utility

Postby vegafacundodaniel » Mon Jun 23, 2014 7:32 pm

Hello everybody,

I have a question please. I'd like to get some information using SORT utility. For ex:

Field A             Field B
AAAAAAA          2000-01-01
AAAAAAA          2001-06-01
AAAAAAA          2013-01-01
BBBBBBBB         1999-01-01
BBBBBBBB         2000-01-01
CCCCCCCC        2007-01-01


I'd like to get this:
AAAAAAA          2013-01-01
BBBBBBBB         2000-01-01
CCCCCCCC        2007-01-01

How could I do that? Any idea, please ?
Thanks in advance
vegafacundodaniel
 
Posts: 61
Joined: Tue Jul 20, 2010 4:27 pm
Has thanked: 1 time
Been thanked: 0 time

Re: SORT utility

 

Re: SORT utility

Postby BillyBoyo » Mon Jun 23, 2014 7:44 pm

Use OUTFIL reporting functions. You'll need NODETAIL,REMOVECC and then SECTIONS (where you specify your control field) and TRAILER3, which would specify the entire data.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: SORT utility

Postby NicC » Mon Jun 23, 2014 10:40 pm

If you had used code tags all those spaces would have been retained.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post