RE: Date type L

[Walden Leverich <walden@xxxxxxxxxxxxxxx>]

Pete, 

Actually, I'd bet that RPG does know this. If you create an RPG program
that does it's output using o-specs and not the write opcode I'd bet
that you got the "correct" default date (provided you didn't reference
the date field in the o-spec). After all, if you use the write statement
you are writing a value for the date field, even if you don't intend to.

-Walden

-----Original Message-----
From: Pete Hall [mailto:peteh@inwave.com]
Sent: Monday, June 29, 1998 10:17 PM
To: MIDRANGE-L@midrange.com
Subject: Re: Date type L


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