You have to delete and then to define your vsam, after doing this you can use the statement that i posted before.
Is this VSAM accessible by CICS? If yes you can use CECI to delete the record you want.
You should be able to do this with your SORT product. My suggestion is that you post this to the SORT forum, indicating which product you use (DFSORT or SYNCSORT) and any relevant details on the release level, etc., and providing as much details as possible about the dataset.
Posted: Thu Mar 26, 2009 10:07 pm Post subject: vsam cluster REPRO REUSE option
If you want to delete all the records in VSAM without deleting VSAM. Use following methods.
method 1) Use COBOL program to do this.
method 2) Define your VSAM file with REUSE option YES.
after that everytime you want to empty the the VSAM file. Use IDCAMS REPRO with REUSE option to copy empty file to VSAM file.
method 3) it is very similar to what is explained in method 2.
If your VSAM file already defined with RESUE option NO. Use ALTER command to make VSAM file reusable and use IDCAMS REPRO with REUSE option to copy empty file to VSAM file.
If required, you can ALTER back VSAM file to NOREUSE. _________________ Natarajan
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