Can we delete records older than 14 months using SORT

kkxlnc · New User Joined: 12 Jun 2005 Posts: 44 Location: Boston

Can we use a sort to delete records which are 14 months older? This process needs to run on a monthly basis, so we cannot hard-code a date to compare.

Any suggestions are welcome.

expat · Posted: Thu Aug 06, 2009 1:00 pm

Is the date stored in the record, if so, at which location and in which format.

If not, how would you determine the age of a record.

Escapa · Posted: Thu Aug 06, 2009 2:20 pm

Show us some sample records from the file..

Also RECFM,LRECL of file.

Frank Yaeger · Posted: Thu Aug 06, 2009 8:31 pm

K2,

You can use the technique discussed in the "Include records using relative dates" Smart DFSORT Trick at:

www.ibm.com/support/docview.wss?rs=0&uid=isg3T7000094

If you need more specific help, give more details.

kkxlnc · New User Joined: 12 Jun 2005 Posts: 44 Location: Boston

The DATE1(-)-56 operand corresponds to a C'yyyy-mm-dd' constant for today's date minus 56 days. So the following
control statement will include only those records with a C'yyyy-mm-dd' date in positions 14-23 greater than
today's date - 56 days.

Frank Yaeger · Posted: Sat Aug 08, 2009 4:16 am

Glad I could help.