Re: Date type L

[Pete Hall <peteh@xxxxxxxxxx>]

At 05:04 PM 6/29/98 -0400, VENU YAMAJALA wrote:
>separators. Now I tried to add data into the PF using SQL by INSERT statement.
>I tried to add data into only one field (say Fld9 which is in ISO format). I
>moved some value 2000-02-29. The record is added. But when I did a SELECT
>statement, surprisingly I found data in all the other fields also. I didnot add
>data into it. The otehr fields got current date as their values. This looked

Venu,

Unless you specify something different, the current date is supposed to be the 
default value for date fields. Unfortunately, RPG doesn't seem to know this, 
but apparently SQL does.

Pete


Pete Hall
peteh@inwave.com 
http://www.inwave.com/~peteh/

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