DBohner-(db)
Legendary Poster
Looking for suggestions....
During a recent migration from an iSeries to Unix/Oracle, several custom tables were not migrated. Post go-live, it is realized that we need those tables for various reasons...
Now the question - what is the best way for Developers go do the search and grab of that information.
Oracles way - R98403B (The B allows us to snag specific tables, right?). If I understand, we need to have a machine with both the current pathcode - AND the pathcode of the legacy system? The machine that does the copy must of both the Oracle Software and Client Access Installed. Seems a bit overkill?
Foreign Tables and ODBC - A Table Conversion can be used to import from a Foreign Table. E1/Oracle needs to be installed and Client Access with ODBC Connections to the iSeries.
Other Means?
I'm trying to get a feel for how other organization snag data from their iSeries/DB2 to their Unix/11G-ish...
(db)
During a recent migration from an iSeries to Unix/Oracle, several custom tables were not migrated. Post go-live, it is realized that we need those tables for various reasons...
Now the question - what is the best way for Developers go do the search and grab of that information.
Oracles way - R98403B (The B allows us to snag specific tables, right?). If I understand, we need to have a machine with both the current pathcode - AND the pathcode of the legacy system? The machine that does the copy must of both the Oracle Software and Client Access Installed. Seems a bit overkill?
Foreign Tables and ODBC - A Table Conversion can be used to import from a Foreign Table. E1/Oracle needs to be installed and Client Access with ODBC Connections to the iSeries.
Other Means?
I'm trying to get a feel for how other organization snag data from their iSeries/DB2 to their Unix/11G-ish...
(db)