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

[Marco Facchinetti <facchinetti@xxxxxxxxx>]

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
+---