RE: SQL 22007

["Joubert, Robert" <RJoubert@xxxxxxxxxxxxxxxxxxxx>]

The date value of '0001-01-01' denotes a date that has no value - and is
usually associated with data fields that have been defined as data type L or
Z (date types).  You can test by checking if the date equals *loval.

-----Original Message-----
From: DeLong, Eric [mailto:EDeLong@xxxxxxxxxxxxxxx]
Sent: Tuesday, February 10, 2004 11:00 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: SQL 22007


Any possibility that you're reading it into a two-digit (*MDY, *DMY, *YMD,
*JUL) or three-digit (*CYMD, *CDMY, *CMDY) year formats?

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: Eric Kempter [mailto:EKempter@xxxxxxxxxxxxxxx]
Sent: Tuesday, February 10, 2004 12:42 PM
To: Midrange Systems Technical Discussion
Subject: SQL 22007


When attempting to read a file via an SQL select statement in RPGLE, I
receive SQL state error 22007 on a record that contains a non NULL date
field valued with 0001-01-01.   To my mind, this is a valid date.  When I
value this field with 2003-01-01, I do not receive an error.  Any thoughts
on what the problem could be?  We are using V5R2.

Thanks in advance for any assistance. 



_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.