Deleting Outdated records in a VSAM
Posted: Mon Dec 07, 2015 3:30 pm
So I have a requirement. I have to create a KSDS VSAM dataset which will get inserted with new records on a daily basis. The records have a date field and that is part of the key.
Now I need to find a way to delete the records which were inserted more than 250 days ago.
So if the difference between the current date and record date is greater than that, is there a VSAM parameter I can give in the cluster to facilitate the requirement of deleting JUST those records or will I have to use a sort card or if not, can you suggest any other way to delete the older records?
I have looked into ERASE and TO and FOR(days) parameter but they seem to apply on the whole cluster instead of specific records.
Please help and let me know if there's anything I haven't made clear.
I am a little new to VSAM so forgive me if my knowledge in that regard isn't that great
Now I need to find a way to delete the records which were inserted more than 250 days ago.
So if the difference between the current date and record date is greater than that, is there a VSAM parameter I can give in the cluster to facilitate the requirement of deleting JUST those records or will I have to use a sort card or if not, can you suggest any other way to delete the older records?
I have looked into ERASE and TO and FOR(days) parameter but they seem to apply on the whole cluster instead of specific records.
Please help and let me know if there's anything I haven't made clear.
I am a little new to VSAM so forgive me if my knowledge in that regard isn't that great