Data export from db2

I need to export data from db2 tables into flat files and import that in sql server 2000. The options I am getting for the flat files are : .ixf, .del and .wsf.
But I need a .txt file or .xls flat file. Please help in this regard.

Also please suggest how to import the flat files in sql server 2000.

re: Data export from db2

Hi,

I dont' know much about importing to M$-SQL, but for the export you should try "OF DEL". This produces delimited data where default column delimiter is a comma (,) and strings are delimited with a double quotation mark ("). This should be usable as csv file.

If needed you may change the delimiters with the modifiers coldel and chardel. Find more information here at the IBM site.

Regards


Doc

re: Data export from db2

Hey it worked.Thanks a lot :)