RE: Initializing a timestamp field when adding a record

Doesn't work with ILE RPG writing to the PF either...sigh...

-----Original Message-----
From: midrange-l-bounces@midrange.com
[mailto:midrange-l-bounces@midrange.com] On Behalf Of
dennis.e.lovelady@accenture.com
Sent: Monday, January 13, 2003 8:16 PM
To: Midrange Systems Technical Discussion
Subject: Re: Initializing a timestamp field when adding a record

Hi, Reeve:

DFU, even when deselecting columns, isn't the same as your first example. 
The fact that YOU don't see the field doesn't mean that DFU doesn't.

However, if you use DFU against the LF you created, you'll be all set.

HTH

Dennis E. Lovelady






"Reeve Fritchman" <reeve@ltl400.com>
Sent by: midrange-l-bounces@midrange.com
01/13/2003 07:38 PM
Please respond to Midrange Systems Technical Discussion

 
        To:     "'Midrange Systems Technical Discussion'"
<midrange-l@midrange.com>
        cc: 
        Subject:        Initializing a timestamp field when adding a record

I'm trying to get a timestamp field initialized to the current time 
whenever
I add a record with an ILE RPG program. 

 

Here's what the PF/LF DDS manual says (p. 44, V5R1 version) when 
explaining
the DFT keyword:

 

If you are defining a timestamp field, you must specify the default value 
in
the following format:

DFT('YYYY-MM-DD-HH.MM.SS.UUUUUU')

If the DFT keyword is not specified, the default value is the current 
time.

 

Here's what I'm doing:

      A            RDATS           Z 

      A                                      TEXT('Add timestamp') 

      A                                      COLHDG(' ' + 

      A                                             ' ' + 

      A                                             'Add timestamp') 

 

So I created a subset LF without the timestamp field in the format, added 
a
record with DFU, and the timestamp was there (the manual, p. 27, alludes 
to
this behavior).  I created a DFU application without the timestamp field 
and
added a record; the timestamp was not set.

 

Am I mis-reading or was it mis-written?  I'm mis-tified.



_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.