Mainframe, MVS and zOS Discussion

Posted: **Mon Jan 18, 2016 11:56 am**

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.

Posted: **Mon Jan 18, 2016 2:49 pm**

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.

Posted: **Tue Feb 09, 2016 11:46 am**

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.

Posted: **Tue Feb 09, 2016 2:48 pm**

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

Mainframe, MVS and zOS Discussion

Unload a table with specific column delimiters and redabale format.

Unload a table with specific column delimiters and redabale format.

Re: Unload a table with specific column delimiters and redabale format.

Re: Unload a table with specific column delimiters and redabale format.

Re: Unload a table with specific column delimiters and redabale format.