loadercli and "set null '' " adds spaces to null values

[Jesus Salvo]

Using loadercli versions 7.5 and 7.6.
I am using compressed format to extract data from several tables, and I would like to have columns which are null to be ... well ... empty in the file.

So I have something like this in a script:


loadercli -n $SAPDB_HOST -d $DBNAME -u dba,dba << EOF
set codetype utf8
set timestamp iso
set boolean '1/0'
set compressed '/\t//'
set null ''
use user comm comm
dataextract from $TABLE outstream '$OUTPUT_DIRECTORY/$TABLE.dat' timestamp 'YYYY-MM-DD HH:MM:SS' compressed


However, the rows that did have null values in certain columns are extracted as spaces. Of course, if I don't specify the "set null" command, the output of those columns are a question mark (>) followed by 19 spaces, as per documentation.

It seems that "set null" only overrides the question mark, and it still have spaces in the extract file. How can I tell loadercli not to put spaces as well ??

Thanks,
John