RE: sql date processing

["Phil" <sublime78ska@xxxxxxxxx>]

I never bothered to look before because I have H datfmt(*iso).  But one of
the parameters for CRTSQLRPGI is DATFMT and the default is *JOB.  So I
changed it to *ISO and it works correctly.

So there's the answer.

Phil
-----Original Message-----
From: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com]On
Behalf Of R. Bruce Hoffman, Jr.
Sent: Wednesday, May 02, 2001 9:27 AM
To: RPG400-L@midrange.com
Subject: Re: sql date processing

The answer is in the message.

DSPMSGD SQL0183 MSGF(QSQLMSG)

It spells out the answer to the problem as well as the acceptable date
ranges for non-ISO formats. The date range limitation for any non-ISO is
limited by the two digits of the year to the current: "window".

For future reference, the SQL codes match messages on the 400, as above. The
SQLSTATE code is cross platform, and will allow any DB2 platform to identify
the errors.


===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - AS/400 Administrator
 -- IBM Certified Specialist - RPG IV Developer

"America is the land that fought for freedom and then
  began passing laws to get rid of it."

     - Alfred E. Neuman

-----Original Message-----
From: Phil <sublime78ska@yahoo.com>
To: RPG400-L@midrange.com <RPG400-L@midrange.com>
Date: Tuesday, May 01, 2001 10:48 PM
Subject: RE: sql date processing


>Try replacing '0001-01-01' with '1970-01-01'
>
>I don't know what the earliest permissible date is.  Hopefully earlier than
>1970.  But by doing this test you'll see that sql doesn't accept
>'0001-01-01' as a valid date.
>
>Phil
>
>-----Original Message-----
>From: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com]On
>Behalf Of Smith, Mike
>Sent: Monday, April 30, 2001 8:13 AM
>To: RPG400-L@midrange.com
>Subject: sql date processing
>
>
>I've have a physical file defined with 2 date fields stored as 'L' data
type
>A Start date and and End Date.   When i read the file  with a Fetch
>statement and the End Date is filled only with '0001-01-01', I get a -183
>error code.
>
>The data doesn't seem to get loaded into my data structure, so i cannot
>manipulate the date, so what do i do?
>
>How do i approach the coding to handle something like this?
>any suggestions?
>
>thanks
>
>Mike
>
>+---
>| This is the RPG/400 Mailing List!
>| To submit a new message, send your mail to RPG400-L@midrange.com.
>| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
>| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator:
>david@midrange.com
>+---
>
>
>_________________________________________________________
>Do You Yahoo!?
>Get your free @yahoo.com address at http://mail.yahoo.com
>
>+---
>| This is the RPG/400 Mailing List!
>| To submit a new message, send your mail to RPG400-L@midrange.com.
>| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
>| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator:
david@midrange.com
>+---

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---