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
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?