Can we migrate DB2 data to Excel

abhishek_mishra · New User Joined: 09 Jan 2007 Posts: 4 Location: india

Hi...i want to migrate a DB2 table to any Excel sheet. Do we have any tool or utility available for this?

Cheers
Abhishek.

ofer71 · Posted: Mon Dec 17, 2007 3:48 pm Post subject:

Use any UNLOAD utility do download the table into a sequential file, use edit command/rexx to put a comma between the fields, transfer to PC, then open as CSV.

O.

dick scherrer · Posted: Mon Dec 17, 2007 9:17 pm Post subject:

Hello,

If your data might contain commas as actual data, you may want to use the tab character (x'05') as the delimiter.

Also, if you have numeric fields with implied decimals, you will want to expand them to include the decimal point and the minus sign if the number might be negative.

It is much easier to properly format the data on the mainframe than it is to have the user try to work with numbers that are not "spreadsheet friendly".