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
 

 

Deleting records using JCL

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IDMS/ADSO
View previous topic :: :: View next topic  
Author Message
deepak.kec

New User


Joined: 26 Feb 2007
Posts: 71
Location: bangalore

PostPosted: Tue May 26, 2009 2:37 pm    Post subject: Deleting records using JCL
Reply with quote

Hi All,

i have some hundred obsolete records which i want to delete. Does anyone have a JCL to delete records?

I know we can delete the records using IDDM but i want to do using a JCL which will reduce the time to delete the records.

Thanks for helping me.
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8117
Location: East Dubuque, Illinois, USA

PostPosted: Tue May 26, 2009 5:11 pm    Post subject:
Reply with quote

JCL can do one thing: run programs. It cannot add records, delete records, change records. It does nothing but run programs. Which program or utility are you planning on using for this task -- you would certainly get better answers if you tell the details?
Back to top
View user's profile Send private message
deepak.kec

New User


Joined: 26 Feb 2007
Posts: 71
Location: bangalore

PostPosted: Tue May 26, 2009 5:25 pm    Post subject:
Reply with quote

I have no idea which utility can be used to delete the records.
If i would have any clue i would have not raised this question to you guys.

Thanks for your suggestion.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10274
Location: italy

PostPosted: Tue May 26, 2009 5:29 pm    Post subject: Reply to: Deleting records using JCL
Reply with quote

why not ask Your IDMS support ??
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8117
Location: East Dubuque, Illinois, USA

PostPosted: Tue May 26, 2009 5:32 pm    Post subject:
Reply with quote

You should have access to the IDMS manuals so what did you find in looking through them? Or, Googling "IDMS utilities" comes back with more than 27,000 hits. It does not seem that you've done much research so far -- so why should we do your job for you and identify the utility?
Back to top
View user's profile Send private message
deepak.kec

New User


Joined: 26 Feb 2007
Posts: 71
Location: bangalore

PostPosted: Fri May 29, 2009 11:00 pm    Post subject:
Reply with quote

I have googled based on ur suggestion but couldn't find much related to IDMS utility. Since not much people work on IDMS so it is difficult find the correct information.

Hope you people could help me in getting the solution.

Thanks to all for there invaluable suggestions.
Back to top
View user's profile Send private message
chaky

New User


Joined: 28 May 2009
Posts: 20
Location: Bangalore

PostPosted: Sat May 30, 2009 12:57 am    Post subject:
Reply with quote

Deepak,

How we can identify a record that it's an obselete record? Do we have some indicator or some date logic like before 20090101 all records are obselete. Please give some example to identify the exact problem.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat May 30, 2009 1:00 am    Post subject:
Reply with quote

Hello,

Quote:
Since not much people work on IDMS so it is difficult find the correct information.
If your organization is licensed to use the product, you can open an issue with CA Support. . .
Back to top
View user's profile Send private message
deepak.kec

New User


Joined: 26 Feb 2007
Posts: 71
Location: bangalore

PostPosted: Sat May 30, 2009 12:09 pm    Post subject:
Reply with quote

we have a list of records which we found are not used in any dialog and programs. So i can keep them in the input dataset and use a utility and delete them. Problem is that i dont know which utility could be used.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat May 30, 2009 3:18 pm    Post subject:
Reply with quote

Hello,

What answer did you get from CA Support?

I suspect you could always write code that would delete the records. . .

I suspect you could unload the data, copy the data bypassing the unwanted entries, and reload the data.
Back to top
View user's profile Send private message
vijayakumar.yellala

New User


Joined: 19 Apr 2006
Posts: 63
Location: Chennai

PostPosted: Wed Jun 10, 2009 6:00 pm    Post subject:
Reply with quote

Hello Deepak,

you may have jcl to add the records in IDD, same JCL you can use for deleting records from the IDD.

For each enviroment they might have given JCLs, check those JCLs, you will find it.
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 -> IDMS/ADSO All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm
No new posts Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts Extract set of records matching on ac... bhaskar_kanteti DFSORT/ICETOOL 3 Mon Mar 06, 2017 7:19 am
No new posts Inserting records based on conditions vickey_dw DFSORT/ICETOOL 9 Wed Feb 22, 2017 1:33 pm


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