I need to get a userstamp into a table and have not managed to figure out how the GENERATED FOR EACH ROW ON UPDATE AS statement works with the SESSION_USER variable in DB2 10.5 (LUW).
Managed to get an implementation working using a function which has a fake variable for forcing the evaluation in update statements:
CREATE OR REPLACE FUNCTION XXX.CURRENT_USER( tmp varchar(128)) SPECIFIC xxx.XXX_CURRENT_USER RETURNS VARCHAR(128) CONTAINS SQL DETERMINISTIC NO EXTERNAL ACTION BEGIN RETURN session_user ; END GO CREATE TABLE xxx ( i INTEGER, t VARCHAR(128) GENERATED ALWAYS AS (XXX.CURRENT_USER(i)) )
However, would be nice have less "hacky" implementation for a basic thing like this.
For the time stamps there is that "FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP" statement but no equivalent for other register variables it seems.
Help is very much appreciatedAnswer1:
Does this work?
CREATE TABLE xxx ( i INTEGER, t VARCHAR(128) WITH DEFAULT session_user );
I don't have DB2 on hand to check, but this is very similar to the syntax used in other databases (although the more typical syntax does not use