Re: When is date field (L) updated?

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Dale

According to the documentation, if you omit the DFT keyword in DDS, it 
uses the current date as the default - this is what you want, right?

Here is something from the DDS guide -

When the program does an output operation to a logical file based on 
this physical file and the record
format in the logical file does not name this field.

So it seems important NOT to directly refer to the field.

Can you do a DSPFFD against the file and see what it really says for 
that field?

HTH
Vern

On 6/25/2012 3:48 PM, dale janus wrote:
> I have a file defined with DDS (it's a long slow process moving to DDL).
> It has a date field defined as type L. The default value is current date,
> I confirmed it as  shown in OPS NAV.
>
> What I want DB2 to do is put in  today's date whenever I add a record.
> What I get is 0001-01-01.
>
> This is the kind of thing I would like to let DB2 handle.  Do I need to
> make it a timestamp field for that to work?   Or change the definition
> with OPS NAV to something else?
>
> I guess I  can always update with current date in RPG, but I'm trying to
> use some of these new shiny tools that are available.
>
>
> ---Dale