× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. October 2006

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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.