Re: When is date field (L) updated?

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