unloading a null field with informix 1

[ejaggers]

unload to fname select col1,col2,col3 from table;
Gives: data1|data2|data3|

unload to fname select col1,’’,col3 from table;
Gives: data1|\ |data3|
Where the second field "\space" represents a null value.

But I want nothing in the second field. i.e: data1||data3|

Does anyone know how to do this?

 

[PHV]

Typed, untested:
unload to fname select col1,(select rowid from table where rowid<0),col3 from table;

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ejaggers]

That worked like a charm!!! Thanks PHV..

 

[mberni]

looks a bit stupid, but you could also do:

unload to fname select col1, nvl(NULL,NULL), col3 from table;