delete a record from a VSAM

futuredba · New User Joined: 08 Jan 2006 Posts: 22 Location: Delhi

Hi,

I want to delete a record from a VSAM. I know the key of the record. But here are certain conditions:
1) I dont want to Del/Def the vsam.
2) I dont want to write any program. Just using any utility.
3) My Vsam is NOREUSEable.

Is it possible? If yes, how?

Thanks,
Sumit

Terry Heinze · Posted: Fri Dec 05, 2008 7:17 am

If you have File-Aid, you might be able to use that.

futuredba · New User Joined: 08 Jan 2006 Posts: 22 Location: Delhi

Hi Terry,

Sorry. I forgot to mention that I want to do it through a Jcl. I don't want to use File-Aid or File-Manager. I tried to use DFSORT, but it failed when the file was NOREUSE.

expat · Posted: Fri Dec 05, 2008 12:11 pm

Then I would guess that the answer to your question is a rather resounding NO

Robert Sample · Posted: Fri Dec 05, 2008 5:42 pm

I echo expat on this -- based on the restrictions you're placing on the "need", there is no available way I am aware of to delete a record in a VSAM file.

futuredba · New User Joined: 08 Jan 2006 Posts: 22 Location: Delhi

I also thought so. Just wanted to confirm this...

Thanks all,
Sumit

GlobalGyan · New User Joined: 31 Jan 2006 Posts: 28

It is been sometime since i have used FileAID, but is there a batch option in FileAID to delete the record? This would generate a JCL and a parm that will be passed to the fileAID batch program to delete the record?

dick scherrer · Posted: Sat Dec 06, 2008 12:31 am

Hello,

Anuj Dhawan · Posted: Sat Dec 06, 2008 12:36 am

Hi GlobalGyan,

Are you saying or asking, am little confused ..

. Yes you can run FileAid in batch..but 'am not able to comment furhter unless I get what exactly do you mean ?

futuredba · New User Joined: 08 Jan 2006 Posts: 22 Location: Delhi

My shop dont have File-Aid instead it has File-Manager. I assume they both are more or less same.

In File-Manager (and hoping in File-Aid too), we can generate batch job only for the Utilities option like create dataset, copy dataset, sreachfor, other catalog services, compare etc etc... But we want to delete a record from a vsam. For doing this, we dont go to Utility option instead go to Edit option and delete it. And in Edit option, we cant generate any jcl.

Please correct me if I am wrong.

Robert Sample · Posted: Sat Dec 06, 2008 1:54 am

If the file is defined in a CICS region, you could use CECI to delete it.

One suggestion that came up here is to print out the entire file and use white-out on the record.

Terry Heinze · Posted: Sat Dec 06, 2008 9:55 am

That method works on my monitor with a green magic marker -- don't see why it can't work with your method, Robert.