Unload a table with column delimiters

[Prasanna G]

Hi

I would like to unload a DB2 table with each of the columns delimited by ; (semicolon). All decimal and integer values should be in readable format in the unloaded file. I tried to use DSNUPROC with the below control card

Code: Select all

DELIMITED COLDEL ';' DECPT '.'   
PUNCHDDN SYSPUNCH                
UNLDDN SYSREC00 EBCDIC  

But the character columns are flanked by " (double quote). Also the length of the unloaded file is in VB format with 32756 as record length. I want the unloaded file to be created in actual length of the table.

Can someone please help me in achieving the above?

Thanks
Prasanna G.