-- in db2 v9 you van use ltrim with additional argument.
-- in db2 v8 use:

SELECT TRANSLATE(LTRIM(TRANSLATE(CHAR(my_decimal_column, ','), '0 ', ' 0')), '0 ', ' 0') FROM my_tab;