Re: When is date field (L) updated?

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Dale

Another thought - you can always use the SQL ALTER TABLE to change that 
column - and there you can set a default that is current date explicitly.

At least, I think it'll let you do that!

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