SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—640322-001
10-29
TRIGGERS Table
5 ACTIVATION_TIME CHAR(2) Activation time:
B Before
A After
6 OPERATION CHAR(2) Operation that fires the trigger:
I INSERT
D DELETE
U UPDATE
7 GRANULARITY CHAR(2) Granularity:
R Row
S Statement
8 COLUMNS_IMPLICIT CHAR(2) Relevant only for UPDATE trigger:
Y Yes
N No
9 ENABLED CHAR(2) Current status of trigger:
Y if enabled
N if not
10 TRIGGER_CREATED LARGEINT Timestamp of creation of the trigger
* Indicates primary key
Column Name Data Type Description