IBM Support

Support PROGRAM NAME on CREATE TRIGGER

News


Abstract

Support PROGRAM NAME on CREATE TRIGGER

Content

You are in: IBM i Technology Updates > Db2 for i - Technology UpdatesDb2 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":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB08","label":"Cognitive Systems"}}]

Document Information

Modified date:
14 January 2020

UID

ibm11167730