RE: Insert of null-values with RPG, SQL or DFU

Maybe you can change the date format in the DATFMT
parameter of the CRTSQLRPGI command to be the same as the
date's format in your database.
--- Phil Groschwitz <sublime78ska@yahoo.com> wrote:
> I have a similar problem with date fields.  When a
> record is inserted (via rpg) the date field has a
> default value = 0001-01-01.  I have a display file pgm
> that uses embedded sql to retrieve the records, and
> when it comes to a record with the default value in a
> date field, a negative sql code is returned.  
> 
> Is there anyway to handle this other than to ensure
> there is a valid date (ie 1970-01-01) in each record? 
> 
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Mail - Free email you can access from anywhere!
> 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
> +---


__________________________________________________
Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere!
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
+---