Page 1 of 1

SORT utility

PostPosted: Mon Jun 23, 2014 7:32 pm
by vegafacundodaniel
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

Re: SORT utility

PostPosted: Mon Jun 23, 2014 7:44 pm
by BillyBoyo
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.

Re: SORT utility

PostPosted: Mon Jun 23, 2014 10:40 pm
by NicC
If you had used code tags all those spaces would have been retained.