TRIGGERPARAMS
This
system table contains all the parameters of a trigger for which the current user has privileges.TRIGGERPARAMS
|
OWNER |
CHAR(32) |
Name of the owner of a table |
|
TABLENAME |
CHAR(32) |
Name of the table |
|
TRIGGERNAME |
CHAR(32) |
Trigger name |
|
PARAMETERNAME |
CHAR(32) |
Name of the parameter |
|
POS |
FIXED(4) |
Original position of the parameter in the trigger |
|
NEW/OLD-TYPE |
CHAR(3) |
Parameter version (NEW | OLD) |
|
DATATYPE |
CHAR(10) |
Data type of the parameter (BOOLEAN | CHAR | DATE | FIXED | FLOAT | TIME | TIMESTAMP) |
|
CODETYPE |
CHAR(8) |
Code attribute of the column (ASCII | EBCDIC | BYTE | UNICODE) |
|
LEN |
FIXED(4) |
Length or precision of the parameter |
|
DEC |
FIXED(3) |
Number of decimal places for parameters with data type FIXED |
|
CREATEDATE |
DATE |
Creation date of the trigger |
|
CREATETIME |
TIME |
Creation time of the trigger |