Writing some table dumps using spool command. problem with linesize limit of 2000. The spool command seems to pad each feild out to it;s maximum length - e.g. I have a comments field in a table which is char(4000). even when this is empty, spool puts out 4k blank spaces which pushes me over the linesize limit so I get each row spread across multiple lines. This in turn makes analyzing the result painful.
I have the following parameters set for the spool
set colsep ,
set pagesize 0
set trimspool on
set headsep off
set linesize 2000
set echo off
set feedback off
Is there anything I can do to have the individual fields trimmed?
Alternative solutions also appreciated