Remove OLD records from file based on date

trevor_rebelo · New User Joined: 18 Aug 2005 Posts: 17

Hi,

I have a req. in which i have to remove 6 yrs all records from a file.

i.e. Suppose first 10 characters is date in YYYY-MM-DD format (e.g 2006-10-31)

Now delete records which has date < current date - 6 yrs data.

Can we do current date - 6 yrs?

Trevor

expat · Posted: Tue May 15, 2007 6:41 pm

That would depend on the sort product installed, and its PTF level, but let's face it, calculating a date of six years ago and coding it isn't going to be much of a task, is it.

trevor_rebelo · New User Joined: 18 Aug 2005 Posts: 17

This job will run every month through scheduler and the everytime we needs to do the check.

Changing the Sort card in production every time is not easy..

Was looking for some generic way of doing it .... else we will have to write Pgm to do it.... around 1 billion records in file..... might need to omit 6M on every run.......

Frank Yaeger · Posted: Tue May 15, 2007 9:03 pm

trevor,

Here's a DFSORT job that will do what you asked for. Just substitute the starting position of your input date field for p (e.g. 21) in the OMIT statement.