Add generated always for each row on update as row change SESSION_USER

Currently exists in Db2 to change current timestamp on INSERT and UPDATE with generated statement like:

create table myschema.mytable (id int, last_timestamp timestamp not null generated always for each row on update as row change timestamp)

insert into myschema.mytable (id) values (1)
update myschema.mytable set id = 2 where id =1

I would like to have something similar for SESSION_USER, to automatically add current session user on INSERT and UPDATE like (this is actual idea):

create table myschema.mytable (id int, last_user varchar(128) not null generated always for each row on update as row change SESSION_USER)

Currently work-around is: create table myschema.mytable (id int, last_user varchar(128) with default session_user) above solves the SESSION_USER for INSERT statement, but for UPDATE we are required to write after update trigger. Now we are required to manually add after update triggers for few hundred tables.

Needed By

Yesterday (Let's go already!)

Post comment

Admin

Ned Whelan

Reply
| Apr 19, 2023

Thank you for submitting this Idea! We have reviewed the ask and will consider it for a future release.

0 reply Hide replies

By clicking the "Post Comment" or "Submit Idea" button, you are agreeing to the IBM Ideas Portal Terms of Use.
Do not place IBM confidential, company confidential, or personal information into any field.

Please enter your email address

RELATED IDEAS

Add generated always for each row on update as row change SESSION_USER