Re: DDL for timestamp column.

Just wanted to reiterate:
<snip>
See also these cool functions from 7.3:

create table qtemp.jr2
(
mychar char(5),
CreatedTS timestamp with default current timestamp,
audit_user VARCHAR(128) GENERATED ALWAYS AS (SESSION_USER),
audit_op CHAR(1) GENERATED ALWAYS AS (DATA CHANGE OPERATION),
Row_Change_TS timestamp for each row on update as row change timestamp not

null
);

insert into qtemp.jr2 (mychar) values('#ENFB');
select * from qtemp.jr2;
#ENFB, 2017-08-22 08:51:26.570501, ROB, I, 2017-08-22 08:51:26.570546

update qtemp.jr2
set mychar='Rocks'
where mychar='#ENFB';

select * from qtemp.jr2;

Rocks, 2017-08-22 08:51:26.570501, ROB, U, 2017-08-22 08:53:28.175547

</snip>


Rob Berendt