DB2 Import utility

dvillani · #1 (**permalink**) 01-07-04, 06:33

Hi All and Happy new Year,
there is anyone that know wich tool could be useful to import data in a DB2 database?
I'm talking of a tool like "Data Transformation Services" present on Microsoft SQL Server. I used and find it very usefull, but now I'm working with DB2 in a very intensive way to import flat files containing data for many tables of my DB. This task is varying very often and I wish to use a tool to help me to do this kind of work.
Thank in advance.

sathyaram_s · #2 (**permalink**) 01-07-04, 06:49

Did you try Control Centre ?

Other than that one, I'm not aware of any tool to do the task with a GUI ...

Cheers
Sathyaram

Quote:

Originally posted by dvillani
Hi All and Happy new Year,
there is anyone that know wich tool could be useful to import data in a DB2 database?
I'm talking of a tool like "Data Transformation Services" present on Microsoft SQL Server. I used and find it very usefull, but now I'm working with DB2 in a very intensive way to import flat files containing data for many tables of my DB. This task is varying very often and I wish to use a tool to help me to do this kind of work.
Thank in advance.

dvillani · #3 (**permalink**) 01-07-04, 06:57

Quote:

Originally posted by sathyaram_s
Did you try Control Centre ?

Other than that one, I'm not aware of any tool to do the task with a GUI ...

Cheers
Sathyaram

I have ran it, but how could be used for this purpose?

DEkart · #4 (**permalink**) 02-16-05, 04:48

I think EMS DB2 Data Import tool is exactly what you need!
http://www.sqlmanager.net/products/db2/dataimport

Internet Services

Web Development

Digital Marketing

Consumer Tech