| Nome da coluna |
Tipo do dado |
Descrição |
Uso |
| NAME |
CHAR(8) NOT NULL |
Name of the trigger and trigger package. |
G |
| SCHEMA |
CHAR(8) NOT NULL |
Schema of the trigger. This implicit or explicit qualifier for the trigger name is also
used for the collection ID of the trigger package. |
G |
| SEQNO |
SMALLINT NOT NULL |
Sequence number of this row; the first portion of the trigger definition is in row 1,
and successive rows have increasing SEQNO values. |
G |
| DBID |
SMALLINT NOT NULL |
Internal identifier of the database for the trigger. |
G |
| OBID |
SMALLINT NOT NULL |
Internal identifier of the trigger. |
G |
| OWNER |
CHAR(8) NOT NULL |
Authorization ID of the owner of the trigger. The value is set to the current
authorization ID (the plan or packge owner for static CREATE TRIGGER statement;
the current SQLID for a dynamic CREATE TRIGGER statement). |
G |
| CREATEDBY |
CHAR(8) NOT NULL |
Authorization ID of the owner of the trigger. The value is set to the current
authorization ID (the plan or packge owner for static CREATE TRIGGER statement;
the current SQLID for a dynamic CREATE TRIGGER statement). |
G |
| TBNAME |
VARCHAR(18) NOT NULL |
Name of the table to which this trigger applies. |
G |
| TBOWNER |
CHAR(8) NOT NULL |
Qualifier of the name of the table to which this trigger applies. |
G |
| TRIGTIME |
CHAR(1) NOT NULL |
Time when triggered actions are applied to the base table, relative to the event that
activated the trigger:
B Trigger is applied before the event.
A Trigger is applied after the event. |
G |
| TRIGEVENT |
CHAR(1) NOT NULL |
Operation that activates the trigger:
I Insert
D Delete
U Update |
G |
| GRANULARITY |
CHAR(1) NOT NULL |
Trigger is executed once per:
S Statement
R Row |
G |
| CREATEDTS |
TIMESTAMP NOT NULL |
Time when the CREATE statement was executed for this trigger. The time value is
used in resolving functions, distinct types, and stored procedures. It is also used to
order the execution of multiple triggers. |
G |
| IBMREQD |
CHAR(1) NOT NULL |
A value of Y indicates that the row came from the basic machine-readable material
(MRM) tape. For all other values, see Release dependency indicators in topic D.0. |
G |
| TEXT |
VARCHAR(3460) NOT NULL |
Full text of the CREATE TRIGGER statement. |
G |
| REMARKS |
VARCHAR(254) NOT NULL |
A character string provided by the user with the COMMENT ON statement. |
G |
| TRIGNAME |
VARCHAR(30) NOT NULL |
Unused |
G |
