Unload a table with specific column delimiters and redabale format.

[Shamshir Rai Luthra]

Hi

I need to unload a DB2 table. And in the unload I want the columns to be delimited by semicolon, ";". Also all decimal values should be converted in to readable format. For this, I tried to use DSNUPROC like this:

Code: Select all

DELIMITED COLDEL ';'  
PUNCHDDN SYSPUNCH                
UNLDDN SYSREC00 EBCDIC 

But this did not work. Character columns are filled with double quotes. And the length of the unload file became 32756/VB while I'd expect it to as the actual length of the table.

What should I do? Please help.

[nicc]

How do you expect the row length to be the same when you are converting packed decimal to zoned decimal? A packed decimal field of, say, 4 bytes length would expand to 7, possibly 8, bytes. If any column has a null value in row then there will be null indicators to take into account in the length as well.

[Shamshir Rai Luthra]

Thanks nicc. But unload was not readable too. Can you please suggest a usual way of doing it?

Would appreciate any help you can provide.

[nicc]

Well, I am not going to search out and read the manual - that is your job.