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 

Upload an MDB into a VSAM file

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> TSO and ISPF
View previous topic :: View next topic  
Author Message
MY4114
Beginner


Joined: 18 Dec 2002
Posts: 8
Topics: 2

PostPosted: Tue Feb 25, 2003 4:55 pm    Post subject: Upload an MDB into a VSAM file Reply with quote

I would like to know the most efficient, less time taking and NO/Minimal manual effort involved process that can be used to upload the tables of an MDB into VSAM files.
Back to top
View user's profile Send private message
Venkata Ramana Reddy
Beginner


Joined: 02 Dec 2002
Posts: 70
Topics: 19
Location: California

PostPosted: Tue Feb 25, 2003 5:36 pm    Post subject: Reply with quote

I think you may have to convert all of your Tables(in MDB) to flat files,transfer those flat files to mainframe,and then REPRO into VSAM files.
_________________
Venkataramana
-- Good judgement comes from experience, and often experience comes from bad judgement.
Back to top
View user's profile Send private message
MY4114
Beginner


Joined: 18 Dec 2002
Posts: 8
Topics: 2

PostPosted: Wed Feb 26, 2003 9:11 am    Post subject: Reply with quote

Thanks for the response. This is what we are doing currently. We are manually converting the MDB tables into flat files and uploading them to mainframes. I wanted to know if we can automate these two activities too or any alternative.
Back to top
View user's profile Send private message
Venkata Ramana Reddy
Beginner


Joined: 02 Dec 2002
Posts: 70
Topics: 19
Location: California

PostPosted: Wed Feb 26, 2003 4:36 pm    Post subject: Reply with quote

I think you may automate the process of creating the flat files from MDB and then transfering those files to mainframe.I think you can write some windows based scripts in Win Runner or Rational Robot or some other scripting tools.

And then in mainframe check for the existance of the files if they exist,REPRO them to VSAM files.
_________________
Venkataramana
-- Good judgement comes from experience, and often experience comes from bad judgement.
Back to top
View user's profile Send private message
MY4114
Beginner


Joined: 18 Dec 2002
Posts: 8
Topics: 2

PostPosted: Mon Mar 03, 2003 10:18 am    Post subject: Reply with quote

Thanks Venkata Ramana. I am using the macros and they are working fine.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> TSO and ISPF 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