-Ursprüngliche Nachricht-
Von: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
Gesendet: Sonntag, 21. April 2002 12:48
An: Multiple recipients of list ORACLE-L
Betreff: RE: data cleansing question
Hi Yechiel,
I'm aware of the NULLIF clause. However my strategy has been to bring the
entire
Stefan,
I've got a question regarding your migration host - oracle,
since I'll have
the same
problem in the near future.
How do you deal with the EBCDIC to ASCII problem ?
Do you migrate from VSAM or DB2 ? Which version of Oracle are you on ?
Can't reply to the second one, but take a
Hello
There are a few considerations:
1) If you import the data using the loader you can use the NULLIF clause
so it will import all zero field as null.
2) Check carefully for usage of the fields in the WHERE part of the SQL.
Putting nulls instead of zero can cause the users to do outer
Database Administrator
Fairfield Resorts, Inc.
Ft. Lauderdale, FL, USA
-Original Message-
From: Yechiel Adar [SMTP:[EMAIL PROTECTED]]
Sent: Sunday, April 21, 2002 5:33 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: data cleansing question
Hello
There are a few
-L
Subject: Re: data cleansing question
Do you have mainframe programs that will be brought over to use this
mainframe data? If so, they will likely have problems with nulls. If
there
will only be new programs accessing this data, then it sounds fine.
Will there by any statistical
Do you have mainframe programs that will be brought over to use this
mainframe data? If so, they will likely have problems with nulls. If there
will only be new programs accessing this data, then it sounds fine.
Will there by any statistical work on these columns? Averages, for example,
will
PM
To: Multiple recipients of list ORACLE-L
Subject: Re: data cleansing question
Do you have mainframe programs that will be brought over to use this
mainframe data? If so, they will likely have problems with nulls. If
there
will only be new programs accessing this data