Oracle -> i5

[Jerry Adams <jerry@xxxxxxxxxxxxxxx>]

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.