RE: SQL 22007

[Kevin Mohondro <kevin.mohondro@xxxxxxxxxxxxxxx>]

I've had a similar problem. I had to change the compile option on the
CRTSQLRPGI command from DATFMT(*JOB) to DATFMT(*ISO) and it cleared the
problem up for me. Hope that helps.

-Kevin
-=-=-=-=-=-=-=-=-=-
Kevin R Mohondro
Programmer/Analyst


> -----Original Message-----
> From: Eric Kempter [mailto:EKempter@xxxxxxxxxxxxxxx]
> Sent: Tuesday, February 10, 2004 10:42 AM
> 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. 
> 

#####################################################################################
Attention:
The information contained in this message and or attachments is intended
only for the person or entity to which it is addressed and may contain
confidential and/or privileged material.  Any review, retransmission,
dissemination or other use of, or taking of any action in reliance upon,
this information by persons or entities other than the intended recipient
is prohibited. If you received this in error, please contact the sender and
delete the material from any system and destroy any copies.

Thank You.
#####################################################################################