sorry I newbie in here. how export database db2 to SQL Server 2000 and MySQL? please help me

zero1987, You can export data in DB2 (you don't mention what version or operating system) to a CSV (comma separated variable) file. SQL Server can accept this file (I would use a DTS (Data Transformation Service) to do this). I assume MySQL can also handle CSV as it is a fairly standard format.

There may be other ways, such as linking to the DB2 from SQL Server and going directly from table to table but I have never done this.

I've once tried to replicate a few tables from DB2 (z/OS) to MySQL through an application (running on Linux and connecting to both DB2 and MySQL through ODBC; it took terribly long (and consumed an unexpected amount of CPU on the mainframe).
After that, I used UNLOAD in DB2 to produce a CSV file, then ftp-ing that file to Linux where I LOAD it into MySQL; all this takes about 100x less time than the first method.

Here are the exact statements:

DB2 utility command:
UNLOAD DATA FROM TABLE mytbl DELIMITED CHARDEL X'7D' UNLDDN filename

Ftp commands:
ASCII
SITE 'charset(sw88591)'
GET filename
BYE

MySQL command:
load data local infile 'filename' replace into table mytbl character set latin1 fields terminated by ',' optionally enclosed by '''';

I use DB2 version 9 in windows xp.I don't understand how export to csv in DB2. please give me tutorial how export to csv.because I am still study DB2 so I still do not understand way export database DB2. please help me

zero1987, the easiest way is to use the Control Center.

Right Click on a Table and select Export... from the pop-up menu.
Then it is just a matter of filling in the information.

Output file box: Type in a path\file name. (you can click on the box with ... to open an explorer type window to find the destination).

File Format: Delimited should be selected. (if you want to change the default of the delimiters click on the Options button).

Select statement: Enter your select statement. A SELECT * FROM table-name is already entered but you can change it to anything you like.

Message File box: Enter a path\file name for the Messages file.

Unless you are doing some thing real fancy, you can ignore the Columns and Schedule tabs at the top.

PS You can click on the SHOW COMMAND button to see the actual command you will be running. If you like, you can copy it out and run it from a command line (or script file). You might want to do this if you have a LOT of tables to export.

how about reading this
EXPORT
and see for del

thanks all

I would suggest you use IXF format for your files. If I am not mistaken it is readable by all db's. You might save your self some hassle if you have special characters in your data.

Try using:

MyDbExplorer

Can anyone confirm? I'm afraid he is misaken because IXF is a db2 dedicated format. But it is Cougar8000 talking here so I am starting to doubt....