Deleting Outdated records in a VSAM

Post your questions related to VSAM

Moderator: Moderator Group

Post Reply
Posts: 1
Joined: Mon Dec 07, 2015 3:22 pm

Deleting Outdated records in a VSAM

Post by tushirsharma » 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 :)


Topic deleted by Admin

Post by academyindia4 » Tue Jan 19, 2016 12:49 pm

<< Content deleted By Admin >>

Post Reply


Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Mainframe Interview questions

Other References
Mainframe Tools and others