Option J. Triggers

The following figure shows an example of this panel:

ADB21J in -------------------- DB2X Triggers ----------------- Row 1 to 4 of 4 
                                                                               
Line commands:                                                                 
 D - Database  T - Table  K - Package  A - Schema auth  I - Interpretation     
 GEN - Generate DDL  Drop - Drop  COM - Comment  CRE - Create  AL - Alter      
 ? - Show all line commands
                                            Table/   Table/                                
                                            View     View                     Created      
S    Schema   Name     Owner     Version  A Schema   Name               T E G By  
     *        *        *         *          *        *                  * * * *            
---- -------- -------  --------  -------- - -------- ------------------ - - - --------     
     DB2ADM2  RPTR1    DB2ADM2   V1       Y DB2ADM2  RPTB1               A U S DB2ADM2      
     DB2ADM2  RPTR1    DB2ADM2   V2       N DB2ADM2  RPTB1               A U S DB2ADM2      
     DB2ADM2  RPTR1    DB2ADM2   V3       N DB2ADM2  RPTB1               A U S DB2ADM2
AL   DSNIBMTS CONNECTI DB2ADM               SYSIBMTS SYSTEXTCONNECTINFO  B I R DB2ADM1      
******************************* END OF DB2 DATA *******************************

Columns

This panel displays the following columns:

S

Input field where you can enter one of the line commands listed on the panel. Enter a question mark (?) on a row to view all valid line commands.

Schema

Name of the schema.

Name

Name of the trigger.

Owner

Authorization ID of the owner of the trigger.

Version

Trigger version for an advanced trigger.

A

Whether the trigger version is active for an advanced trigger:

Y

Yes.

N

No.

blank

The trigger is a basic trigger.

Table/View Schema

Schema of the table or view to which this trigger applies.

Table/View Name

Name of the table or view to which this trigger applies.

T

Trigger time, which is one of the following values:

A

After.

B

Before.

I

Instead of.

E

Trigger event, which is one of the following values:

I

Insert.

U

Update.

D

Delete.

G

Granularity of the trigger, which is one of the following values:

R

For each row.

S

For each statement.

Created By

Primary authorization ID of the user who created the trigger.