I have a requirement . There is a file containing records from date 2000-02-09 to 2008-02-09.Is there a way through DFSORT to check the date parameter ? If so, my requirement is to remove all records less than 2007-02 ( year - 1) from one file and write those out to another.
It could be a weird question , but if anyone could help me that would be great.
when you say year-1 did you mean current date - 1 year? You are already in 2009 , so year -1 would be 2008-02. If that is the case the following JCL will give you the desired results. Date2(-) is of the format YYYY-MM