DB2 Universal Database for iSeries SQL Reference

SYSTRIGDEP

The SYSTRIGDEP view contains one row for each object referenced in the WHEN clause or the triggered SQL statements of a trigger. The following table describes the columns in the SYSTRIGDEP view:

Table 130. SYSTRIGDEP view

Column Name System Column Name Data Type Description
TRIGGER_SCHEMA TRIGSCHEMA VARCHAR(128) Name of the schema containing the trigger.
TRIGGER_NAME TRIGNAME VARCHAR(128) Name of the trigger.
OBJECT_SCHEMA BSCHEMA VARCHAR(128) Name of the schema containing the object referenced in the trigger.
OBJECT_NAME BNAME VARCHAR(128) Name of the object referenced in the trigger.
OBJECT_TYPE BTYPE CHAR(24) Indicates the object type of the object referenced in the trigger:

ALIAS
The object is an alias.

FUNCTION
The object is a function.

INDEX
The object is an index.

MATERIALIZED QUERY TABLE
The object is a materialized query table.

PACKAGE
The object is a package.

PROCEDURE
The object is a procedure.

SCHEMA
The object is a schema.

SEQUENCE
The object is a sequence.

TABLE
The object is a table.

TYPE
The object is a distinct type.

VIEW
The object is a view.
PARM_SIGNATURE SIGNATURE VARCHAR(10000)
Nullable
This column identifies the routine signature.

Contains the null value if the object is not a routine.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]