Re: Connect Oracle & Db2

From: Victor Tsien <vtsien_at_iris.ctd.anl.gov>
Date: 1997/05/17
Message-ID: <01bc62e7$a80fb3a0$0bad8992@lyra.ctd.anl.gov>#1/1

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 Sat May 17 1997 - 00:00:00 CDT