QUESTION POSED ON: 18 October 2004
What authority would a non-DBA need to create a DB2 trigger? We are using Endevor and processors to create triggers. We were successful in
creating stored procedures and thought triggers required similar authorization.
CREATE TRIGGER ZJCTSS00.CASEU1
AFTER UPDATE OF
CASE_YYMM_DT
ON ZJCTSS00.CASE
REFERENCING OLD AS OLDROW
NEW AS NEWROW
FOR EACH ROW MODE DB2SQL
BEGIN ATOMIC
UPDATE ZJCTSS00.NAMEX
SET CASE_YYMM_DT = NEWROW.CASE_YYMM_DT
WHERE CASE_PROJ_NUM = OLDROW.CASE_NUM
AND SOURCE_IND = 'R';
END# SQLCODE = -20100, ERROR: AN
ERROR OCCURRED WHEN BINDING A TRIGGERED SQL STATEMENT. INFORMATION
RETURNED: SEC
NUMBER : 2 SQLCODE -551, SQLSTATE 42501, AND MESSAGE TOKENS
ENDVID2,UPDATE,ZJCTSS00.NAMEX.CASE_YYMM_DT
SQLSTATE = 56059 SQLSTATE RETURN CODE
SQLERRP = DSNXODML SQL PROCEDURE DETECTING ERROR
|
