ASSERT_TRIGGER_EXISTS procedure

Raises an assertion error if the specified trigger doesn’t exist.

Prototypes

ASSERT_TRIGGER_EXISTS(ASCHEMA VARCHAR(128), ATRIGGER VARCHAR(128))
ASSERT_TRIGGER_EXISTS(ATRIGGER VARCHAR(128))

Description

Raises the ASSERT_FAILED_STATE state if the trigger specified by ASCHEMA and ATRIGGER does not exist. If not specified, ASCHEMA defaults to the value of the CURRENT SCHEMA special register.

Parameters

ASCHEMA
Specifies the schema containing the trigger to check. If omitted, defaults to the value of the CURRENT SCHEMA special register.
ATRIGGER
Specifies the name of the trigger to check.

Examples

Test the UTILS.VACATIONS_INSERT trigger exists:

CALL ASSERT_TRIGGER_EXISTS('UTILS', 'VACATIONS_INSERT');

Test the existence of the trigger VACATIONS_DELETE in the current schema:

CALL ASSERT_TRIGGER_EXISTS('VACATIONS_DELETE');

SQL0438N  Application raised error or warning with diagnostic text:
"DB2INST1.VACATIONS_DELETE                          does not exist".
SQLSTATE=90001