Re: loading large data friles into Oracle from MVS

From: Dmitry <support_at_ispirer.com>
Date: Fri, 9 Nov 2001 15:35:06 +0200
Message-ID: <9sgm0i$13fndl$1@ID-75577.news.dfncis.de>

Hello,

Try to setup an ODBC driver to access MVS database. For example, Neon System, Shadow Direct driver.
We had the same project. But we migrated IBM DB2 V5.1 in OS/390 into Oracle 8.1.7 in Sun Solaris platforms.
You can use migration tool Chyfo (www.ispirer.com/products). It can export data from any ODBC datasource and generates DDL scripts for Oracle and command scripts and control files for Oracle SQLLoader.

Best regards, Dmitry.

"hani" <hanton32_at_hotmail.com> wrote in message news:8dc139d4.0111070854.3ca6b599_at_posting.google.com...
> We are setting up an Oracle 9i server to house a new datamart.
>
> We need to load data files from MVS sources into Oracle.
>
> I would like some advice...
>
>
> 1. Is this possible using just an ETL tool like the one in 9i ?
>
> 2. Will I have to buy a 3rd party tool for this ?
>
> 3. Should I just FTP the files and then use sql*loader ?
>
> 4. is there an open gateway for Oracle to MVS ?
>
> any advice appreciated.
Received on Fri Nov 09 2001 - 07:35:06 CST