RE: sql date processing

["Brown, Diane R." <DBrown@xxxxxxxxxxxxxxxx>]

Specify DATFMT(*ISO) when you compile your program.

-----Original Message-----
From: Smith, Mike [mailto:Mike_Smith@RGCResources.com]
Sent: Monday, April 30, 2001 7: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
+---
+---
| 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
+---