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

[jpcarr@xxxxxxxxxxxx]

Phil

Try compiling your SQL RPG program with the compile parameter
of  DATFMT *ISO   instead of DATFMT *JOB and see what happens.

John Carr

--------------------------------------------


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?
Phil Groschwitz

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