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 Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm
No new posts VSAM Space Allocation mrgnndhmk JCL & VSAM 7 Sat Apr 22, 2017 12:42 am
No new posts Sort Large record length cmsmoon DFSORT/ICETOOL 14 Tue Apr 11, 2017 5:49 pm
No new posts Format record to remove Leading zeroes Learncoholic DFSORT/ICETOOL 14 Wed Apr 05, 2017 2:43 pm


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