Re: Copy Oracle database to DB2/400

[Bruce.Odum@xxxxxxxxxxxxxx]

You could pull the SQL Schema from Oracle and recreate it on the AS/400
using create table.  You may have to create some user defined fields to
match the Oracle system but this way you would have to identical looking
databases






Bruce Odum
Delivery Services
2601 Technology Drive
Orlando, Fl 32804-8068
Phone : (407) 513-6264 Fax : (407) 659-0438
E-mail : bruce.odum@cbs.fiserv.com



                    David.X.Kahn@gsk.co
                    m                          To:     midrange-l@midrange.com
                    Sent by:                   cc:
                    midrange-l-admin@mi        Fax to:
                    drange.com                 Subject:     Copy Oracle 
database to DB2/400


                    10/22/2001 11:07 AM
                    Please respond to
                    midrange-l






We have a large legacy Oracle database (40 GB) that we would like to import
into DB2/400. What are our sensible options for creating a DB2 version of
this database retaining as far as possible the data management information
such as field names and attributes? If we could at the same time create
access paths based on those in the Oracle database that would be a bonus.
This is a one time load - it does not have to be kept current.

Dave...

=======================================================
The opinions expressed in this communication are my own and do not
necessarily reflect those of my employer.

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.