Re: MIDRANGE-L Digest, Vol 5, Issue 1942

Jerry,

IBM has a web site dedicated to it. Check:

http://www-03.ibm.com/servers/enable/site/db2/porting.html

There are (free) conversion tools form going from Oracle to DB2. Also, check 
with your BP and/or IBM. They have (of course) the utmost interest in someone 
converting to DB2.

Hope this helps.

Regards,

Luis Rodriguez



------------------------------

message: 7
date: Mon, 09 Oct 2006 07:14:04 -0500
from: Jerry Adams 
subject: Oracle -> i5

I have been approached about taking on a project to convert an Oracle db 
(don't know which version) to a System i5.


While a database is a database, there are differences between Oracle and 
DB2.  This, though, is outside of my experience level so I thought I 
would bounce this one off of you dudes (and dudettes).  Anyone done this 
sort of thing?  If so, what are the processes involved?  And is there 
any documentation for it?


I suppose that, first, one would somehow download the SQL DDL from 
Oracle and create the tables and views on the i5.  Seems rudimentary 
enough, even if there is no magical way to do this and it has to be done 
by hand (though I think there should be a way to get the DDL to an IFS 
folder).  But how would one get the actual data to the i5?  CPYF doesn't 
seem workable; maybe CPYFRMIMPF?  Or CPYFRMSTMF?  I came across a 
CPYFRMPCD but that looks like it's meant for Office/400 stuff.


Then, of course, there's the whole interface (presentation) layer.  But 
that's going beyond anything that I've been told about the project.


Thanks.