MAINFRAME - TIP OF THE DAY :
When you specified V for RECFM parameter, LRECL value is largest record in the file plus 4 bytes. These four bytes contain the actual length of each variable length record in the file
Programmers Voted for below topics. Please Vote for good Posts.
Thank You! for your feedback. Connecting to the server. Please Wait...
Posted: Mon Dec 07, 2015 3:30 pm Post subject: Deleting Outdated records in a VSAM
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
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Cobol Tutorial This cobol tutorial covers most of the important topics like STRING, UNSTRING, COMP, COMP-3.....
DB2 Tutorial DB2 Tutorial focuses on DB2 COBOL Programming. Explains in simple language. Some Chapters are locked, Forum members have free access to these chapters
CICS Tutorial This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming...
JCL Tutorial This is most popular JCL tutorial from mainframegurukul. It does contain important jcl ....
SORT Tutorial This Tutorial covers all important aspects of DFSORT. Has more SORT examples