View previous topic :: View next topic |
Author |
Message |
MY4114 Beginner

Joined: 18 Dec 2002 Posts: 8 Topics: 2
|
Posted: Tue Feb 25, 2003 4:55 pm Post subject: Upload an MDB into a VSAM file |
|
|
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 |
|
 |
Venkata Ramana Reddy Beginner

Joined: 02 Dec 2002 Posts: 70 Topics: 19 Location: California
|
Posted: Tue Feb 25, 2003 5:36 pm Post subject: |
|
|
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 |
|
 |
MY4114 Beginner

Joined: 18 Dec 2002 Posts: 8 Topics: 2
|
Posted: Wed Feb 26, 2003 9:11 am Post subject: |
|
|
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 |
|
 |
Venkata Ramana Reddy Beginner

Joined: 02 Dec 2002 Posts: 70 Topics: 19 Location: California
|
Posted: Wed Feb 26, 2003 4:36 pm Post subject: |
|
|
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 |
|
 |
MY4114 Beginner

Joined: 18 Dec 2002 Posts: 8 Topics: 2
|
Posted: Mon Mar 03, 2003 10:18 am Post subject: |
|
|
Thanks Venkata Ramana. I am using the macros and they are working fine. |
|
Back to top |
|
 |
|
|