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.
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives