I have searched this forum , but I did not find any thing related to my problem. I have a DB2 column defined as varchar(300) which is used to store dates in packed decimal form. The date is stored as an array of 5 bytes each. Now if there are 10 dates then the length of the column is 50 bytes. When I try to unload this column using DSNTIAUL, the first 50 bytes are unloaded as is , but the rest of 250 bytes is padded with low-zeroes (x'00') . Is there any option to change the pad character to spaces when unloading the data?