Re: loading large data friles into Oracle from MVS

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Thu, 08 Nov 2001 12:12:28 GMT
Message-ID: <3bea7657.2841325@news>

In a valiant and sublime effort,hani
frowned, dipped a thumb in soot and doodled:

>
>
>1. Is this possible using just an ETL tool like the one in 9i ?

Dunno.

>
>2. Will I have to buy a 3rd party tool for this ?

Most probably not.

>
>3. Should I just FTP the files and then use sql*loader ?
>

That would definitely work.

>4. is there an open gateway for Oracle to MVS ?
>

There used to be one, between ORACLE and DB2. I don't think it can be used to read flat files, but I'll stand corrected if that's not the case.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Thu Nov 08 2001 - 06:12:28 CST