Re: Exporting Oracle Data to DB2
Date: 1995/05/19
Message-ID: <3piuct$61j_at_bones.knx.tva.gov>#1/1
In article <3o85rb$ash_at_tilde.csc.ti.com>, tryphon_at_ti.com (Tryphon Georgallides) says:
>
>Hello gang,
>
>I have a client who came up with the "excellent idea" of exporting
>his ORACLE V6 Data and import it into an MVS DB2 DataBase.
>As you can imaging this means big trouble.
>Has anyone out there done such a thing before ?
>Do I stand any chance of succeeding or will I have to import
>data manually ?
>Ideally is there a tool that can perform such tasks ?
>
>Thanks for reading,
>Tryphon.
I have a Pro*C program which is very similar to a DB2 utility (DSNTIAUL). This will produce a flat file and the SQL*Loader control cards to load the data into the table. Since DB2's load utility and SQL*Loader are so similar you should be able to use this and edit the control cards a little to load the data into a DB2 table. Let me know if you'd like a copy of the program and I'll tell you our anonymous ftp site where I've placed a copy of it.
Greg Flannery
Database Administration
Tennessee Valley Authority
Received on Fri May 19 1995 - 00:00:00 CEST