I am aware about export solution but am looking some solution for truncate white space on console save data. There might be something on Unix or CMD on that we can set page and column variable for session to display page and according save data in text file.
Eliminating padded blanks / trailing spaces in a DB2 VARCHAR column
Originally Posted by rmazzola
I have the same issue... have you found a solution ?
Looks like it has been a while and not sure if anyone posted a solution. I did not try this with earlier DB2 versions but with DB2 V11, if you just use the CHAR function on a VARCHAR column it returns the values by automatically eliminating the padded blanks / trailing spaces. You may have already found this but wanted to post it again for the benefit of others.
When tried this query "SELECT BUS_PROCESS FROM Prefix.Busisness" on a VARCHAR(50) column BUS_PROCESS it returned 'SE Payments.......................................'
But when I tried ""SELECT CHAR(BUS_PROCESS) FROM Prefix.Busisness" it returned 'SE Payments'. No padded blanks.