| 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...
 |  |