RE: Migration of ORACLE data base to DB2/400.

Here is one possibility, do you have connectivity from the 400 to the
Oracle machine? If  so perhaps you can extract the oracle data to a
"flat file" and ftp it to the 400. I am making an assumption that the
Oracle is running on some flavor of Unix so ftp will get the first
conversion ASCII to EBCDIC done for you. Your questionable areas will be
date, timestamp columns and varchar columns but since you are going from
Oracle to DB2/400 you should be ok. Also pay attention to NUMBER fields,
make sure you extract them in a   display format.

You may be able to ftp directly to the AS/400 DB2 structure (use the
physical file name) but in case you can not, use the CPYF utility to get
the data in, you may need to tinker with the CPYF options a bit.

There are other tools, for instance we use Data Joiner but we have an
ongoing need to keep Oracle data refreshed from DB2 and this sort of
option is pricey!

-----Original Message----- 
From: Sudhakar_Annavaram [ mailto:Sudhakar_Annavaram@xxxxxxxxxx
<mailto:Sudhakar_Annavaram@xxxxxxxxxx> ] 
Sent: Thursday, September 04, 2003 6:36 AM 
To: 'COBOL Programming on the iSeries/AS400' 
Subject: Migration of ORACLE data base to DB2/400. 


Hello all, 

I have been working on COBOL/400, RPG/400 for past some years, but I got
a new job to do now. I have to migrate ORACLE database to DB2/400, Could
some one suggest me "the ways and means" of migrating database from
ORACLE server to DB2/400. are there any tools used for this purpose?

Your help is highly appreciated. 

Cheers 
Sudhakar 
************************************************************************
** 
This email (including any attachments) is intended for the sole use of
the intended recipient/s and may contain material that is CONFIDENTIAL
AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or
copying or distribution or forwarding of any or all of the contents in
this message is STRICTLY PROHIBITED. If you are not the intended
recipient, please contact the sender by email and delete all copies;
your cooperation in this regard is appreciated.

************************************************************************
** 
_______________________________________________ 
This is the COBOL Programming on the iSeries/AS400 (COBOL400-L) mailing
list To post a message email: COBOL400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,

visit: http://lists.midrange.com/mailman/listinfo/cobol400-l
<http://lists.midrange.com/mailman/listinfo/cobol400-l>  
or email: COBOL400-L-request@xxxxxxxxxxxx 
Before posting, please take a moment to review the archives 
at http://archive.midrange.com/cobol400-l
<http://archive.midrange.com/cobol400-l> .