× 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.



Schemas --- me.... I would buy ERWin.

Reverse engineer the database schemas into ERWin. ERWin establishes a
connection to the database and reads the catalogs for the meta-data and
builds the database in the tool.

Correct and edit in the tool.
Change the target database in the tool to the 400.
Finish corrections and edits.

Recreate the generation scripts
Use OpsNav to execute the scripts against the 400.

That puts the database there and documents it.

Next, export the data from Oracle. Most DBs have import/export functions in
multiple formats, including csv.

Import the data (load) to DB2. On the 400, this is CPYFRMIMPF.

These last two steps are much faster (loads and unloads) than other forms,
like ODBC or DPropR or whatever, and are generally refered to in everybody's
docs as load and unload. The 400 can do loads in parallel, given the
resources.

===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - AS/400 Administrator
 -- IBM Certified Specialist - RPG IV Developer

"America is the land that fought for freedom and then
  began passing laws to get rid of it."

     - Alfred E. Neuman

-----Original Message-----
From: David.X.Kahn@gsk.com <David.X.Kahn@gsk.com>
To: midrange-l@midrange.com <midrange-l@midrange.com>
Date: Thursday, October 25, 2001 5:11 AM
Subject: Re: Copy Oracle database to DB2/400


>Many thanks to Chuck Morehead, Bruce Odum, Nathan Andelin and David Morris
>for their suggestions. I think my main problem now is going to be getting
>the co-operation of the "keepers of the Oracle". I think there are likely
>to be some technical objections, and I'll naturally throw any of these
>straight out to midrange-l for comment.
>
>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.
>



As an Amazon Associate we earn from qualifying purchases.

This thread ...


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.