Now, Get RPG Codes in all three formats only on this website on every RPGLE related programming article.

Fixed, /Free and Fully Free RPG


SYSTRIGUPD Catalog Table for SQL Trigger

SYSTRIGUPD Catalog Table for SQL Trigger
SYSTRIGUPD Catalog Table for SQL Trigger, sql trigger, as400,ibmi, db2 catalog, ibm catalog, systrigupd
SYSTRIGUPD Catalog Table for SQL Trigger

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

SYSTRIGUPD

This view contains the specific information about each column identified in the UPDATE column list

Structure of SYSTRIGUPD


Column Name Description
TRIGGER_SCHEMA Name of the schema containing trigger
TRIGGER_NAME Name of the trigger
EVENT_OBJECT_SCHEMA Schema name containing the table of the trigger
EVENT_OBJECT_TABLE Name of the table
TRIGGERED_UPDATE_COLUMNS Column specified in the UPDATE column list
SYSTEM_TRIGGER_SCHEMA System schema name
SYSTEM_EVENT_OBJECT_SCHEMA System schema name containing the table or view
SYSTEM_EVENT_OBJECT_TABLE System table name of the table or view

Example

Select * from QSYS2.SYSTRIGUPD

Result


Related Post

Post a Comment

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