nulls into Oracle Oracle
Johnson, Harold A EDUC:EX
Harold.A.Johnson@gems1.gov.bc.ca
Wed, 30 Apr 2003 15:20:15 -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_01C30F66.4078AE7C
Content-Type: text/plain;
charset="iso-8859-1"
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_01C30F66.4078AE7C
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=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></BODY></HTML>
------_=_NextPart_001_01C30F66.4078AE7C--