On Jun 5, 4:18 am, Captain Paralytic wrote: > I have a file which contains a timestamp in the format: > YYYYMMDDHHMMSSMM > starting at position 27. > > Is it possible to have DFSORT remove records which are more than a > month old where a month is defined as 28 days? > > If it is possible, can someone suggest the correct invocation?
I believe these DFSORT control statements will do what you asked for: OPTION COPY OMIT COND=(27,8,CH,LT,DATE1-28) You'll need z/OS DFSORT V1R5 PTF UK90007 or DFSORT R14 PTF UK90006 (April, 2006) in order to use DFSORT's relative date function. If you don't have the April, 2006 PTF, ask your System Programmer to install it (it's free). For complete details on all of the new DFSORT and ICETOOL functions available with the April, 2006 PTF, see: www.ibm.com/servers/storage/support/software/sort/mvs/peug/ Frank Yaeger - DFSORT Development Team (IBM) - [EMAIL PROTECTED] Specialties: PARSE, JFY, SQZ, ICETOOL, IFTHEN, OVERLAY, Symbols, Migration => DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort/ ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
