From an earlier post I gathered that DB2 does have fewer reporting capabilities than Oracle but I though it didnt hurt to ask if in DB2 one can trim the trailing spaces when spooling data to a file.

i.e. in SQLPlus fir Oracle one can say "set trimspool on" and have no spaces trailing after the last field value in the select statement.

Is there a way of achieving the same in DB2 using commands/options? I want to use alternatives using PERL or other third party utilities only if absolutely necessary.