OS/390 DB2 v6.1
Anyone know how to create a before trigger that will set my partition number - such as:

CREATE TRIGGER FSDBA.FSSTULOG NO CASCADE
BEFORE INSERT ON FSDBA.WWW_STUDENT_LOG
REFERENCING NEW AS NEW_ROW
FOR EACH ROW
MODE DB2SQL
BEGIN ATOMIC
SET NEW_ROW.LOG_PARTITION = SELECT DAYOFWEEK(CURRENT_DATE) FROM SYSIBM.SYSDUMMY1
;
END
;

Got it working:

SET CURRENT SQLID = 'FSDBA';

--#SET TERMINATOR ~

CREATE TRIGGER FSDBA.FSSTULOG NO CASCADE

BEFORE INSERT ON FSDBA.WWW_STUDENT_LOG REFERENCING NEW AS N

FOR EACH ROW MODE DB2SQL

BEGIN ATOMIC

SET N.LOG_PARTITION = DAYOFWEEK(CURRENT_DATE);

END ~