nulls into Oracle Oracle
Johnson, Harold A EDUC:EX
Harold.A.Johnson@gems1.gov.bc.ca
Wed, 30 Apr 2003 16:09:51 -0700
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C30F6D.7C08A8A0
Content-Type: text/plain;
charset="iso-8859-1"
thnx. yes, both databases are allowing nulls - this is the old RDB 1858
null values that's getting in the way. I guess I'll have to do checks and
assign a "null" in PH when appropriate.
-----Original Message-----
From: Edis, Robert [mailto:Robert.Edis@blistex.com]
Sent: Wednesday, April 30, 2003 3:56 PM
To: 'powerh-l@lists.swau.edu'
Subject: RE: nulls into Oracle Oracle
G'day Harold
I am assuming you mean Oracle Rdb and Oracle 9.n (or 8.n or 7.n).
How is your PHD set to handle NULL values in the receiving database? If it
is not already then set it to NULL VALUES ALLOWED.
How is your PHD set to handle conversion of NULLs it reads from the source
database? This is in the system settings at the beginning of the PDL
script. Make sure PH it not converting NULLs to something other than NULL.
Oracle Rdb allows you to put a zero in a date column. Oracle 9 (or 8 or 7)
does not if I remember correctly. It has to be a 'real' date or NULL.
What if you let the 1858 date get written to the Oracle 9 (or 8 or 7) DB and
then run PL/SQL scripts afterwards to convert just those dates to NULLs?
Regards,
Blue
-----Original Message-----
From: Johnson, Harold A EDUC:EX [mailto:Harold.A.Johnson@gems1.gov.bc.ca]
Sent: Wednesday, April 30, 2003 5:20 PM
To: 'powerh-l@lists.swau.edu'
Subject: nulls into Oracle Oracle
Hi all. I'm using VMS Powerhouse (830d) to convert data directly from an
RDB database to an Oracle Oracle database. When I assign a field to the
"OO" database, a NULL value from RDB gets converted to that old "1858/11/17
00:00:00.00" null date. Is there anyway to force an OO null into the field
without checking every single field in RDB for "if ... is null"?????
If I don't assign anything to a field, then it gets assigned properly to a
"~".
thnx!
------_=_NextPart_001_01C30F6D.7C08A8A0
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=431100623-30042003><FONT face=Arial color=#0000ff
size=2>thnx. yes, both databases are allowing nulls - this is the old RDB
1858 null values that's getting in the way. I guess I'll have to do
checks and assign a "null" in PH when appropriate.</FONT></SPAN></DIV>
<DIV><SPAN class=431100623-30042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=431100623-30042003></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Edis, Robert
[mailto:Robert.Edis@blistex.com]<BR><B>Sent:</B> Wednesday, April 30, 2003
3:56 PM<BR><B>To:</B> 'powerh-l@lists.swau.edu'<BR><B>Subject:</B> RE: nulls
into Oracle Oracle<BR><BR></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=062184922-30042003>G'day Harold</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=062184922-30042003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=062184922-30042003>I am
assuming you mean Oracle Rdb and Oracle 9.n (or 8.n or
7.n).</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=062184922-30042003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=062184922-30042003>How
is your PHD set to handle NULL values in the receiving database? If it
is not already then set it to NULL VALUES ALLOWED. </SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=062184922-30042003>How
is your PHD set to handle conversion of NULLs it reads from the source
database? This is in the system settings at the beginning of the PDL
script. Make sure PH it not converting NULLs to something other than
NULL.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=062184922-30042003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=062184922-30042003>Oracle Rdb allows you to put a zero in a date
column. Oracle 9 (or 8 or 7) does not if I remember correctly. It
has to be a 'real' date or NULL.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=062184922-30042003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=062184922-30042003>What
if you let the 1858 date get written to the Oracle 9 (or 8 or 7) DB and then
run PL/SQL scripts afterwards to convert just those dates to
NULLs?</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=062184922-30042003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=062184922-30042003>Regards,</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=062184922-30042003>Blue</SPAN></FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Johnson, Harold A EDUC:EX
[mailto:Harold.A.Johnson@gems1.gov.bc.ca]<BR><B>Sent:</B> Wednesday, April
30, 2003 5:20 PM<BR><B>To:</B> 'powerh-l@lists.swau.edu'<BR><B>Subject:</B>
nulls into Oracle Oracle<BR><BR></FONT></DIV>
<DIV><SPAN class=395241422-30042003><FONT face=Arial color=#0000ff size=2>Hi
all. I'm using VMS Powerhouse (830d) to convert data directly
from an RDB database to an Oracle Oracle database. When I assign a
field to the "OO" database, a NULL value from RDB gets converted to that old
"<FONT face=r_ansi size=2>1858/11/17 00:00:00.00" <FONT face=Arial>null
date. Is there anyway to force an OO null into the field without
checking every single field in RDB for "if ... is
null"?????</FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=395241422-30042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=395241422-30042003><FONT face=Arial color=#0000ff size=2>If
I don't assign anything to a field, then it gets assigned properly to a
"~".</FONT></SPAN></DIV>
<DIV><SPAN class=395241422-30042003></SPAN> </DIV>
<DIV><SPAN class=395241422-30042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=395241422-30042003><FONT face=Arial color=#0000ff
size=2>thnx!</FONT></SPAN></DIV>
<DIV><SPAN class=395241422-30042003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><FONT face=Arial color=#0000ff
size=2></FONT> </DIV></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C30F6D.7C08A8A0--