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.
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
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".