var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: equivalent of set trimspool on
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.