prgaj1 Beginner
Joined: 01 Jul 2003 Posts: 6 Topics: 5 Location: Pennsylvania, USA
|
Posted: Fri Jul 11, 2008 7:07 am Post subject: SYNCSORT - |
|
|
Hi,
I have a file which contain data for seven years. Yearly I change my sort parameter to only get the last two years data. I was wondering if I could use a DATE parameter in SYNCSORT to prevent remembering to change the parameters.
Currently the Sort Parameter look as follow:
OMIT COND=(06,02,CH,EQ,C'00',OR,
06,02,CH,EQ,C'06',OR,
06,02,CH,EQ,C'05',OR,
06,02,CH,EQ,C'04',OR,
06,02,CH,EQ,C'03',OR,
06,02,CH,EQ,C'02',OR,
06,02,CH,EQ,C'01')
I was thinking of adding current date2
SORT FIELDS=COPY
OUTREC FIELDS=(1,68,DATE2)
Then compare the dates
SORT FIELDS=COPY
OMIT COND=(06,02,Y2T,GE,71,02,Y2T)
Not sure if this is correct and I cannot find a syncsort manually
Any suggestions... |
|