Re: Unload file problem....
In article <70nufj$ret$1@news.xmission.com>,
Abhay Mannur <abhay@cheerful.com> wrote:
>
> If I execute
>
> unload to xx.unl
> select field1, "", ""
> from tab>
> I'm expecting a output
> field1|||
This is not actually correct. You should expect two delimiters
in case you unloading NULL value. Unloading of empty string is
different. It should be '\\ '.
> but I get
> field1||\\ |
This can be bug. I mean it should return the same value for
all empty strings.
>
> Can anybody explain it ? If I try to add more "" in the select,
> this happens with the last ""
Check also bugs for unload in TechInfo Center. There is an
explanation of '\\ ' for "" there.
>
> Thanks.
> Abhay Mannur.
>
>
Regards
--
Vardan Aroustamian
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own