X$Trigger
The X$Trigger system table is associated with the file TRIGGER.DDF. X$Trigger contains information about the triggers defined for the database. The structure of X$Trigger is as follows:
Table C-23 X$Trigger System Table Structure
| Column Name |
Type |
Size |
Case Insensitive |
Description |
| Xt$Name |
CHAR |
30 |
Yes |
Trigger name. |
| Xt$Version |
USMALLINT |
2 |
N/A |
Trigger version. A 4 indicates Scalable SQL v4. |
| Xt$File |
USMALLINT |
2 |
N/A |
File on which trigger is defined. Corresponds to Xf$Id in X$File. |
| Xt$Event |
UNSIGNED |
1 |
N/A |
0 for INSERT, 1 for DELETE, 2 for UPDATE. |
| Xt$ActionTime |
UTINYINT |
1 |
N/A |
0 for BEFORE, 1 for AFTER. |
| Xt$ForEach |
UTINYINT |
1 |
N/A |
0 for ROW (default), 1 for STATEMENT. |
| Xt$Order |
USMALLINT |
2 |
N/A |
Order of execution of trigger. |
| Xt$Sequence |
USMALLINT |
2 |
N/A |
0-based sequence number. |
| Xt$Misc |
LONGVARCHAR
(LVAR) |
<=4054 |
N/A |
Internal representation of trigger. |
A trigger that is long enough may require multiple entries in Trigger.DDF. Each entry has the same trigger name in the Xt$Name field, and is used in the order specified by the Xt$Sequence field.
Three indexes are defined for the X$Trigger table, as follows:
Table C-24 X$Trigger System Table Index Definitions
| Index Number |
Segment Number |
Column Name |
Duplicates |
Case Insensitive |
Segmented |
| 0 |
0 |
Xt$Name |
No |
Yes |
Yes |
| 0 |
1 |
Xt$Sequence |
No |
N/A |
No |
| 1 |
0 |
Xt$File |
No |
N/A |
Yes |
| 1 |
1 |
Xt$Name |
No |
Yes |
Yes |
| 1 |
2 |
Xt$Sequence |
No |
N/A |
No |
| 2 |
0 |
Xt$File |
Yes |
N/A |
Yes |
| 2 |
1 |
Xt$Event |
Yes |
N/A |
Yes |
| 2 |
2 |
Xt$ActionTime |
Yes |
N/A |
Yes |
| 2 |
3 |
Xt$ForEach |
Yes |
N/A |
Yes |
| 2 |
4 |
Xt$Order |
Yes |
N/A |
Yes |
| 2 |
5 |
Xt$Sequence |
Yes |
N/A |
No |
Index Number corresponds to the value stored in the Xi$Number column in the X$Index system table. Segment Number corresponds to the value stored in the Xi$Part column in the X$Index system table.
