Re: SQR and null dates

[ANDERSD2 <ANDERSD2@OAKWOOD.ORG>]

Make sure the variable you are using to INSERT into the table is reset to
null prior to assigning it a value.  I have found that if I do not do this
it sometimes creates a little havoc.  Further, prior to the insertion,
validate the value of the variable to see if it is null.  Create logic to
accommodate the null value for the date by using a dummy value or some kind
of messaging for user cleanup.

Dave

-----Original Message-----
From: Jonathan Sprenke [mailto:jsprenke@AMAZON.COM]
Sent: Wednesday, June 27, 2001 2:54 PM
To: SQR-USERS@list.iex.net
Subject: SQR and null dates


SQR 6.0.4
Sun solaris
peoplesoft 8 sp1
peopletools 8.13
oracle 8.1.6

We are running sqr programs that grab a date from one table and update it on
another table. When null dates are grabbed and inserted and i go look at the
result in sql plus i see that '00-DECEMB' has been inserted or a crazy
random date which in YYYYMMDD format comes out looking like 9902/10/03 is
inserted. When i do the same operation sqlplus using sql i do not get this
result. Does anyone have any suggestions?