MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

How to dynamiclly create a VSAM RRDS file

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Application Programming
View previous topic :: View next topic  
Author Message
Harvey
Beginner


Joined: 10 Nov 2004
Posts: 3
Topics: 1
Location: Chicago

PostPosted: Wed Nov 10, 2004 12:46 pm    Post subject: How to dynamiclly create a VSAM RRDS file Reply with quote

I'm writing a tcp/ip application to upload weekly files from Windows to MVS VSAM RRDS files. I want to dynamically delete/create the VSAM RRDS file in my MVS client. According to the documentation, SVC99 can only be used to dynamically allocate an existing VSAM dataset. Is it possible to dynamically delete/create a VSAM file? If so how?
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12372
Topics: 75
Location: San Jose

PostPosted: Wed Nov 10, 2004 1:18 pm    Post subject: Reply with quote

harvey,

Can't you just generate the IDCAMS control cards dynamically which will delete and re-create the vsam clusters?

If you let us know the requirement , may be we can suggest an alternative approach

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Harvey
Beginner


Joined: 10 Nov 2004
Posts: 3
Topics: 1
Location: Chicago

PostPosted: Wed Nov 10, 2004 2:01 pm    Post subject: Reply with quote

I need to upload a large number of big files each week to MVS. The current method is to FTP the files to sequential files and then run IDCAMS to delete and deifne the VSAM RRDS files and then REPRO the sequential files to VSAM RRDS. Due to the large number and size of these files I don't want to have both a sequential and VSAM version of the same file. The time required for this is also significant. The size of the files can also very from week to week. So I'd like to simplify the creation of the VSAM RRDS files in a tcp/ip client that I have. I already have the client/server code for uploading my files, I now need to know how to create the VSAM RRDS file dynamically. After that I just have to load the VSAM file which is simple.
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12372
Topics: 75
Location: San Jose

PostPosted: Wed Nov 10, 2004 2:11 pm    Post subject: Reply with quote

Harvey,

I am confused with the usage "dynamically create VSAM Clusters". Do you want to create the vsam clusters with a different name every week? or is the vsam cluster name the same every week?

Quote:

I don't want to have both a sequential and VSAM version of the same file.


The load step can also delete the file. code
Code:

//SORTIN   DD DSN=YOUR SEQ FILE,
//            DISP=(OLD,DELETE,KEEP)



After the successful completion of the step , the seq file is deleted.

Hope this helps...

Cheers

kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Harvey
Beginner


Joined: 10 Nov 2004
Posts: 3
Topics: 1
Location: Chicago

PostPosted: Wed Nov 10, 2004 2:21 pm    Post subject: Reply with quote

The dataset names will not change from week to week. The size of the files may change so the VSAM RRDS file must be deleted and redefinesd. There can be up to 300 files, so I don't want to have to define these through JCL. Also I might only be uploading a subset of files so I need to automate which ones to delete and redefine. I want to do this through code, not JCl so I have full control.
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12372
Topics: 75
Location: San Jose

PostPosted: Wed Nov 10, 2004 2:29 pm    Post subject: Reply with quote

harvey,

Generate the JCL for deleting and loading the selective VSAM clusters on client side and just FTP the JCL with Filetype=jes. check this link for an example.

http://www.mvsforums.com/helpboards/viewtopic.php?t=931&highlight=filetype+jes

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Application Programming All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group