Home » Infrastructure » Other Operating Systems » Converting Oracle to DB2
Converting Oracle to DB2 [message #113780] Tue, 20 November 2001 05:58 Go to next message
George Soley
Messages: 14
Registered: July 2001
Junior Member
Can anyone share experiences converting Oracle to DB2?
Re: Converting Oracle to DB2 [message #113789 is a reply to message #113780] Fri, 07 December 2001 09:38 Go to previous message
Scott Graham
Messages: 3
Registered: March 2001
Junior Member
: Can anyone share experiences converting Oracle to DB2?

Some time ago we were trying to convert Oracle data
to DB2 data for data warehousing purposes. I believe
it was under DB2 os/390 release V410. We used PC
rexx for OS2 to acess the data in Oracle.
We had some success converting the data. Datatype
number was a challenge. We did not work with lob datatypes.
Table names and column names had to be modified due to
mainframe DB2 limitations for the length.
We attempted to recreate some Oracle STD reports
in DB2 which proved more difficult because of the
differences in SQL between the 2 databases.
Previous Topic: Re: Accessing Oracle on UNIX from OS/390 COBOL
Next Topic: Oracle8i 8.1.7 on Z/900
Goto Forum:
  


Current Time: Wed Sep 17 02:51:33 CDT 2014

Total time taken to generate the page: 0.15310 seconds