Display Trigger
The MaxL display trigger statement helps you view details about triggers that track changes to selected Essbase cube areas.
Note:
The application containing the trigger must be started in order to use this statement.
Table 3-4 Output Columns
| Column | Description |
|---|---|
|
application |
The name of the application that contains the database. |
|
database |
The name of the database that contains the trigger. Essbase lists only databases that contain triggers. |
|
name |
The name of the trigger. |
|
definition |
The MaxL trigger statement (for example, create or replace trigger) |
|
enabled |
Whether Essbase is set to monitor the trigger. Values: TRUE or FALSE. To change the value, use alter trigger. |
Example
display trigger on database Sample.Basic;This example displays the output columns:
Table 3-5 Display Trigger MaxL Output
| application | database | name | definition | enabled |
|---|---|---|---|---|
| Sample | Basic | WatchCosts | create or replace trigger | TRUE |