Re: SQL Table with ROW CHANGE TIMESTAMP

On 15 Mar 2013 07:54, Anderson, Kurt wrote:

Just got back from the WMCPA conference and I'm using today to apply
some of the learning that occurred earlier this week.

One thing I learned about was being able to have my SQL table
automatically set the last change timestamp field w/o me doing it.
Example:
ChgDate TIMESTAMP FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP NOT NULL

I added some records via DBU and saw that this worked great.

Unfortunately this seems to be de-simplifying the embedded SQL in my
program.
I had Insert into BillAgentP Values(:ds_Insert);
Where ds_Insert is a Qualified DS defined like the file. But now
that doesn't work b/c it doesn't like that I'm updating ChgDate. Is
my only recourse to list out all the fields except for ChgDate?

I'm at IBM i 7.1

And if that column is defined using IMPLICITLY HIDDEN specification on the ROW CHANGE TIMESTAMP? That specification "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." Perhaps the DS defined with the external TABLE honors [or should honor] that?