Lynne Olney wrote:
>
> I need to know if (and briefly, how) you can transfer data between a
> mainframe DB2 table and an Oracle database. I am very familiar with DB2
> but this is my first exposure to Oracle. I know that I'll be learning a
> lot in the near future, but this is the problem at hand right now and I
> have no idea how to approach it.
>
> Please e-mail me at MOLER_at_EROLS.COM
>
> Thank you!!!
If you are transferring data from Oracle to DB2:
Since Oracle's export command format is not compatible with
DB2's import format, you need to write SQL*PLUS scripts that
basically execute SQL SELECT statements. You can use the
SQL*PLUS 'COLUMN A01 FORMAT 9999999999' type format to
force numerics into a specific format; -or- the
'COLUMN A02 FORMAT A5' type format to force alphanumerics
into a similar format (see ORACLE: The Complete Reference
by Oracle Press; ISBN #:0-07-882097-9). Prior to executing
the actual SQL portion of your script, be sure to issue
a 'SPOOL D:\filename' so that output from the SELECT statement
will go to disk. Also be sure to set your pagesize to zero,
headings off, and echo off (this prevents I/O to your screen
which slows the entire process significantly especially for
tables with 200k+ rows). After the SQL has executed,
be sure to reset these same options or you will not receive
any confirmations back to your screen in SQL*PLUS.
Once your script has completed, you will need a program to
parse the 'D:\filename' by fixed position to get your data.
If you are transferring data from DB2 to Oracle:
The same export/import restrictions apply. You
will need to write DB2 QMF or SPUFI scripts
to similarly perform the above. I won't go into
specifics since you stated you are well versed in
DB2.
Good Luck. You may also email be directly.
Received on Wed Aug 27 1997 - 00:00:00 CDT