unloading a null field with informix
unloading a null field with informix
(OP)
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?
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?
Talk To Other Members
RE: unloading a null field with informix
unload to fname select col1,(select rowid from table where rowid<0),col3 from table;
Hope This Helps, PH.
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?
RE: unloading a null field with informix
RE: unloading a null field with informix
unload to fname select col1, nvl(NULL,NULL), col3 from table;