I've attempted to create a trigger:

--#SET TERMINATOR #
CREATE TRIGGER NOBACKDT
NO CASCADE BEFORE UPDATE ON NZMF.EVENTT
REFERENCING NEW AS A
FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
SET A.LAST_UPD_TMSTMP =
CURRENT TIMESTAMP;
SET A.CMPL_DT =
(SELECT B.CMPL_DT
FROM NZMF.CMPL_DT_CNSTRNT B
WHERE DATE(B.TMSTMP) <> '0001-01-01');
END
#
--#SET TERMINATOR ;

When I run the create using SPUFI, I get the following error:

DSNT408I SQLCODE = -20100, ERROR: AN ERROR OCCURRED WHEN BINDING A TRIGGERED
SQL STATEMENT. INFORMATION RETURNED: SECTION NUMBER : 3 SQLCODE -104,
SQLSTATE 42601, AND MESSAGE TOKENS B,+ ) -

DSNT418I SQLSTATE = 56059 SQLSTATE RETURN CODE

DSNT415I SQLERRP = DSNHPARS SQL PROCEDURE DETECTING ERROR

DSNT416I SQLERRD = 0 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION

DSNT416I SQLERRD = X'00000000' X'00000000' X'00000000' X'FFFFFFFF'

X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION


Can anyone out there help explain what it is I'm doing wrong, or if what I'm trying to do can be done at all.... I'm under the gun to get this trigger created as it is impacting a very big design decision on whether or not we can be sure that financial transactions cannot be back-dated.

Thank you in advance for your assistance and expertise...