Null Handling

[reachmexyz]

Hello all

I am trying to load 2 columns into a table. One of the columns can be null.in the xformer i have used NullToEmpty(FieldName) and loaded into database. When i query the database, i see <Null> in that field. I was expecting an empty string. I am not expecting <Null> as i have already handled it. Is Empty string not differenct from null?
Please reply

[synsog]

What Database you are using as target?

[reachmexyz]

Oracle 9i

[reachmexyz]

Oracle 9i

Can somebody please help me on this

[chulett]

Be patient, people post when they can - this isn't a 24 hour hotline.

Also, please learn to use the Reply to topic link, there's no need to quote something every dang time.

[chulett]

While nulls and empty strings are two different things, Oracle is perfectly happy to turn one into the other. Add $APT_ORACLE_PRESERVE_BLANKS to your job and set it to "true", see if that helps.

[reachmexyz]

While nulls and empty strings are two different things, Oracle is perfectly happy to turn one into the other. Add $APT_ORACLE_PRESERVE_BLANKS to your job and set it to "true", see if that helps.

Thanks for the reply.
Unfortunately it is not working. what can i do more to make empty string stay as empty string instead of convertin to null.

[chulett]

Apparently the Reply to topic link is not working either. [sigh]

"Not working" doesn't really give us much to go on, how about more information? Say, your job design, stages used (particularly the target stage), settings there, etc etc etc. Details are your friend.

[Sreenivasulu]

You need to give further details on the issue OR you yourself need to try with one column and observe the results.
Regards
Sreeni

[ray.wurlod]

Unfortunately it is not working.

"Not working" is the meaning of "unemployed".

[Poovalingam]

In Oracle, when you insert a empty string, this will be inserted as null I guess.

create table xx ( c1 varchar2(4));

insert into xx values ('');

select * from xx where c1='';
ans: no rows selected.

select * from xx where c1 is null;

Ans: c1
---