Re: Connect Oracle & Db2

t

Victor Tsien (vtsien_at_iris.ctd.anl.gov) wrote:
: The best tool you should use is Oracle's Transparent Gateway, it is a
: product, very much like sqlnet. You can dblink the tables from DB2/mvs to
: your Oracle and joint the tables already on Oracle. If you don't have
: transparent gateway, you can use dsntep2 to convert the table to a flat
: file and then ftp to unix, where you use sqlload to load into an Oracle
: corr table. You can schedule the job and sync the time and make the job
: automatic. I used to be DB2 DBA on MVS and later an Oracle DBA on Unix.
: For data type conversion, you need to know Oracle doesn't have timestamp.
: If you need to convert a timestamp, you should convert the millisecond
: portion to an Oracle sequence number. With transparent gateway, it does
: that internally.
 

: Uri Margalit <urimr_at_ibm.net> wrote in article
: <337d8445.169072_at_news.ibm.net.il>...
Received on Sun May 18 1997 - 00:00:00 CDT