Re: include current date in logical file

Ah, but does one REALLY need to create the view or index which omits this
field in order for it to be updated automatically even by RPG RLA? Keeping
in mind that the original thought was that if you do not then RLA will
slap an initial value in there. One workaround was to use the initialize
with external default. But what about:
IMPLICITLY HIDDEN
Indicates the column is not visible in SQL statements unless it is
referred to explicitly by name. For example, SELECT * does not include any
hidden columns in the result. A table must contain at least one column
that is not IMPLICITLY HIDDEN.

I suppose the rub here is "... in sql statements...". RLA is not SQL. So
I can't
CREATE TABLE ...
(...,
LastUpdated timestamp generated always for each row on update as row
change timestamp implicitly hidden,
...)
and expect it won't be initialized to 0001-01-01... by RLA, because RLA
does not respect "implicitly hidden", true?

Rob Berendt