Importing data into UDB DB2 tables.

Jeff Kalman

Importing data into UDB DB2 tables.
Hi all,
I've completed exporting data from DB2 tables on the OS 390 into IXF files
on the Windows NT server. I then created the UDB DB2 tables on the server
and am now working on populating the UDB DB2 tables. I can use some
assistance on the "IMPORT" syntax to import the data from the IXF files
into the DB2 UDB tables.

TIA.
Jeff



Mohammed Nayeem

Re: Importing data into UDB DB2 tables.
(in response to Jeff Kalman)
Hi Jeff

I appreciate if you can give full syntax of the command used for exporting data
from
from DB2 tables on the OS 390 in in IXF file.
How u did ??

Thanks
Nayeem


---------------------- Forwarded by Mohammed Nayeem/MoMedicaid/US on 12/21/2000
12:44 PM ---------------------------


Jeff Kalman <[login to unmask email]> on 12/21/2000 12:44:09 PM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Mohammed Nayeem/MoMedicaid/US)

Subject: Re: Importing data into UDB DB2 tables.



Hi all,
I've completed exporting data from DB2 tables on the OS 390 into IXF files
on the Windows NT server. I then created the UDB DB2 tables on the server
and am now working on populating the UDB DB2 tables. I can use some
assistance on the "IMPORT" syntax to import the data from the IXF files
into the DB2 UDB tables.

TIA.
Jeff








Jeff Kalman

Re: Importing data into UDB DB2 tables.
(in response to Mohammed Nayeem)
Export syntax is:

export to d:\vcstst11\exports\t002x.ixf of ixf
messages d:\vcstst11\exports\t002x.imp
select * from vcstst11.t002x

Jeff