Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Delete a particular record from VSAM

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
anandprabhu

New User


Joined: 04 Dec 2008
Posts: 4
Location: Chennai

PostPosted: Tue Aug 11, 2009 10:53 am    Post subject: Delete a particular record from VSAM
Reply with quote

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
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue Aug 11, 2009 11:04 am    Post subject:
Reply with quote

/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
Back to top
View user's profile Send private message
anandprabhu

New User


Joined: 04 Dec 2008
Posts: 4
Location: Chennai

PostPosted: Tue Aug 11, 2009 11:12 am    Post subject:
Reply with quote

Thanks for the info expat icon_smile.gif

Can i use DFSORT for the above mentioned actions ?
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue Aug 11, 2009 11:19 am    Post subject:
Reply with quote

Search the DFSORT forum, I'm sure it has been discussed a few times in there
Back to top
View user's profile Send private message
anandprabhu

New User


Joined: 04 Dec 2008
Posts: 4
Location: Chennai

PostPosted: Tue Aug 11, 2009 11:41 am    Post subject:
Reply with quote

Thank you !
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Tue Aug 11, 2009 9:42 pm    Post subject:
Reply with quote

Quote:
i would like to delete a single record based in some parameters.


What parameters? What exactly identifies the single record you want to delete?
Back to top
View user's profile Send private message
anandprabhu

New User


Joined: 04 Dec 2008
Posts: 4
Location: Chennai

PostPosted: Wed Aug 12, 2009 9:57 am    Post subject:
Reply with quote

Thanks for asking Frank icon_smile.gif

I found the solution in the DFSORT forum. By using a simple OMIT condition i was able to achieve that. Thanks again
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Wed Aug 12, 2009 9:33 pm    Post subject:
Reply with quote

Good.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Record Not found in AlX but record re... mukun264 COBOL Programming 5 Fri Mar 24, 2017 9:28 am
No new posts Count the length of the record & ... sreekusr DFSORT/ICETOOL 4 Thu Mar 23, 2017 7:52 pm
No new posts Updating a VSAM file with DISP=OLD sheersh JCL & VSAM 8 Tue Mar 14, 2017 6:14 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts IMS DB-How to update a record (a sing... Nic Clouston IMS DB/DC 9 Thu Mar 09, 2017 4:38 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us