Sorry for not answering your follow-on question - but it does not show up on
my news reader. I found it now on google.groups.
Anyway...
To LOAD FROM CURSOR from DB2/iSeries tables you have to set up a federated
environment in your DB2 UDB database. The steps in short (you can read about
this in the online manuals in detail)
1. set in DBM CFG FEDERATED to YES
2. Do a CREATE SERVER for your iSeries database you connected via DB2
Connect
3. Define a USER MAPPING to map your userid on your DB2 UDB host to a user
on iSeries
4. Create a NICKNAME for each iSeries Table you will load from
5. Define a Cursor with a SELECT on a NICKNAME
6. Start LOAD FROM <name> OF CURSOR
to be honest - I have not done this with Db2 UDB and iSeries but with DB2
UDB and DB2 z/os and it worked like a charm
Joachim
PS: the link to the DB2 Information Center:
http://publib.boulder.ibm.com/infoce...help/index.jsp
Hi,
I installed that DB2 Connect. Could you specify your idea of that load
from cursor system? Any links to guides or exapmples?
I allready managed to create connection to iSeries, but then i
discovered that there is no db2move command in DB2 Connect product...
Now I am creating a replica of that original iSeries library into DB2
UDB to get exporing enabled. But I guess there is still many problems
before data is moved...
Joachim Klassen wrote:
AFAIK, without DB2 Connect functionality you're lost.
With DB2 Connect you could use DB2's federated feature to integrate
DB2/400
tables in a DB2 UDB database and then use UDB's LOAD FROM CURSOR to
smoothly
move your data from iSeries to DB2 UDB.
HTH
Joachim
"erkki" <ma*****@operamail.com> schrieb im Newsbeitrag
news:ai*************@read3.inet.fi...
Hi,
I have to move iSeries library to new DB2 database. Is there any easier
way to do this moving operation than exporting all tables in iSeries into
text files and then import them into DB2 Express?
I am looking for same kind of function like db2move between two DB2
databases.
