News
Abstract
Support PROGRAM NAME on CREATE TRIGGER
Content
You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Functional Enhancements > Support PROGRAM NAME on CREATE TRIGGER
Provides the ability to specify a short name for the created trigger program.
When this is not supplied, the database will determine the system name, which could lead to differences in the system name for the trigger program across different machines.
CREATE TRIGGER tr1_trigger_program_21 AFTER UPDATE OF c1 ON TR1
REFERENCING OLD AS o NEW AS n
FOR EACH ROW MODE DB2ROW
PROGRAM NAME trg21
BEGIN ATOMIC
INSERT INTO tr2 VALUES(default, o.c1, n.c1);
END
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]
Was this topic helpful?
Document Information
Modified date:
14 January 2020
UID
ibm11167730