View previous topic :: View next topic
|
Author |
Message |
prgaj1
New User
Joined: 13 Jul 2007 Posts: 18 Location: Pennsylvania
|
|
|
|
Hi
I want to omit all records from a file that is more than two year prior to current year. How would I do this in SYNCSORT?
In DFSORT it would be something like this:
SORT FIELDS=COPY
OUTREC OVERLAY=(69:&DATE2-24)
OUTFIL BUILD=(01,68),INCLUDE=(06,04,Y2T,GE,71,04,Y2T)
this will add current date -24 months to the end of my record and then will compare the year in the 6 byte with the year I just added.... how can one do this in SYNCSORT?
Thanks |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello prgaj1 and welcome to the forums,
Which release of Syncsort is in use on your system?
If you are not sure, you can find the release at the top of the sysout from a sort execution. |
|
Back to top |
|
|
prgaj1
New User
Joined: 13 Jul 2007 Posts: 18 Location: Pennsylvania
|
|
|
|
Hi
We using SYNCSORT FOR Z/OS 1.2.3.1R |
|
Back to top |
|
|
|