SYSTRIGGERS Catalog Table for SQL Trigger

SYSTRIGGERS Catalog Table for SQL Trigger
SYSTRIGGERS Catalog Table for SQL Trigger, SYSTRIGGERS, catlog table in db2 ibm, as400,ibmi, db2 catalog, ibm catalog view
SYSTRIGGERS Catalog Table for SQL Trigger

This article contains the SYSTRIGGERS catalog table used for SQL triggers.

SYSTRIGGERS

This view contains the specific information about the trigger in SQL schema

Structure of SYSTRIGGERS


Column Name Description
TRIGGER_SCHEMA Name of the schema containing trigger
TRIGGER_NAME Name of the trigger.
EVENT_MANIPULATION INSERT/DELETE/UPDATE/READ/MULTI
EVENT_OBJECT_SCHEMA Schema name containing table or view of the trigger
EVENT_OBJECT_TABLE Name of the table or view of the trigger
ACTION_ORDER Indicates the order in which the trigger will be fired.
ACTION_CONDITION WHEN clause / NULL value if no WHEN clause
ACTION_STATEMENT SQL statement text
ACTION_ORIENTATION Trigger activated at each ROW/STATEMENT
ACTION_TIMING BEFORE/AFTER/INSTEAD
TRIGGER_MODE DB2ROW / DB2SQL
ACTION_REFERENCE_OLD_ROW Name of Old Row
ACTION_REFERENCE_NEW_ROW Name of New Row
ACTION_REFERENCE_OLD_TABLE Name of Old Table
ACTION_REFERENCE_NEW_TABLE Name of New Table
SQL_PATH SQL path was used when the trigger was created.
CREATED Timestamp
TRIGGER_PROGRAM_NAME Trigger program
TRIGGER_PROGRAM_LIBRARY Trigger program library
OPERATIVE The trigger is operative or not (Y/N)
ENABLED The trigger is enabled or not (Y/N)
THREADSAFE The trigger is thread-safe or not (Yes/No/Unknown)
MULTITHREADED_JOB_ACTION SYSVAL / MSG / NORUN / RUN
ALLOW_REPEATED_CHANGE Update event condition
TRIGGER_UPDATE_CONDITION ALWAYS / CHANGE
TRIGGER_DEFINER Name of the user that defined the trigger.
TRIGGER_TEXT Lable statement
LONG_COMMENT Comment statement
ROUNDING_MODE C/D/F/G/E/H/U
SYSTEM_TRIGGER_SCHEMA System schema name.
SYSTEM_EVENT_OBJECT_SCHEMA System schema name containing table or view
SYSTEM_EVENT_OBJECT_TABLE System table or view name
EVENTUPDATE Update event fired (Y/N)
EVENTINSERT Insert event fired (Y/N)
EVENTDELETE Delete event fired (Y/N)

Example

Select * from QSYS2.SYSTRIGGERS 

Result


Related Post

Post a Comment

© AS400 and SQL Tricks. All rights reserved. Developed by Jago Desain