Delete a particular record from VSAM

anandprabhu · New User Joined: 04 Dec 2008 Posts: 4 Location: Chennai

Hi all,

I would like to know how to delete a particular record in a VSAM KSDS using JCL program. Since the dataset is huge i would like to delete a single record based in some parameters. Thanks

expat · Posted: Tue Aug 11, 2009 11:04 am

/RANT ON
Once more let us clarify exactly what JCL is.

it is Job Control Language.

By itself it does nothing. It is used to invoke the chosen program and to define which datasets are to be used by the DD names associated with the chosen program.

JCL does not have magical powers that solve all problems, JCL is merely the vehicule for telling the processor which program you want it to execute.
/RANT OFF
You will need to
(a) Write and execute a program
(b) Use your SORT product
(c) Unload, delete the record, reload the VSAM file

anandprabhu · New User Joined: 04 Dec 2008 Posts: 4 Location: Chennai

Thanks for the info expat

Can i use DFSORT for the above mentioned actions ?

expat · Posted: Tue Aug 11, 2009 11:19 am

Search the DFSORT forum, I'm sure it has been discussed a few times in there

anandprabhu · New User Joined: 04 Dec 2008 Posts: 4 Location: Chennai

Thank you !

Frank Yaeger · Posted: Tue Aug 11, 2009 9:42 pm

anandprabhu · New User Joined: 04 Dec 2008 Posts: 4 Location: Chennai

Thanks for asking Frank

I found the solution in the DFSORT forum. By using a simple OMIT condition i was able to achieve that. Thanks again

Frank Yaeger · Posted: Wed Aug 12, 2009 9:33 pm

Good.