Home > IT Answers > Database > Move from DB2/400 flat-file system to Oracle
DebraTart
0 pts.
 Move from DB2/400 flat-file system to Oracle
DB2 Universal Database
Rao wrote in with this question recently: "We are planning to move from a DB2/400 flat-file system to Oracle. We do not have any relations in DB2/400. I want to extract the Metamodel(total DDL scripts) from DB2/400 and go for data modeling. Initially, I thought Oracle Migration Work Bench (OMWB)would work. Unfortunately, it does not support V5R4 of DB2/400 on the iSeriees. So I can?t use OMWB. ERwin DataModeler is unable to extract the relations directly from the database. Do you know which approach I should take? -- Debra Tart, associate editor, Search400.com

Software/Hardware used:
ASKED: January 20, 2006  11:00 AM
UPDATED: January 23, 2006  3:41 PM
RELATED QUESTIONS
Answer Wiki:
On then 400, you can use RTVSQL to retrieve the DDL of each object you want, then you can analyse this DDL. I don't know anything in Oracle. RTVSQL source is at http://jplamontre.free.fr/AS400/RTVSQL.htm
Last Wiki Answer Submitted:  January 23, 2006  3:41 pm  by  JPLamontre   0 pts.
All Answer Wiki Contributors:  JPLamontre   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _