View previous topic :: View next topic
|
Author |
Message |
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 |
|
Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
|
|
If you have File-Aid, you might be able to use that. |
|
Back to top |
|
|
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. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Then I would guess that the answer to your question is a rather resounding NO |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
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. |
|
Back to top |
|
|
futuredba
New User
Joined: 08 Jan 2006 Posts: 22 Location: Delhi
|
|
|
|
I also thought so. Just wanted to confirm this...
Thanks all,
Sumit |
|
Back to top |
|
|
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? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
I don't want to use File-Aid or File-Manager. |
Other than File-Aid being explicitly rejected as an option, it could work |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
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 ? |
|
Back to top |
|
|
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. |
|
Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8696 Location: Dubuque, Iowa, USA
|
|
|
|
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. |
|
Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
|
|
That method works on my monitor with a green magic marker -- don't see why it can't work with your method, Robert. |
|
Back to top |
|
|
|