_TRIGGERLEVEL System Variable
Contains a read-only numeric value indicating the current trigger procedure nesting level.
_TRIGGERLEVEL = nExpression
Parameters
- nExpression
Contains the current trigger procedure nesting level. _TRIGGERLEVEL contains 1 when the initial trigger procedure is executing. If a trigger procedure causes another trigger procedure to fire, _TRIGGERLEVEL is incremented by 1. _TRIGGERLEVEL contains 0 if a trigger procedure is not executing.
Remarks
Use CREATE TRIGGER to create a Delete, Insert, or Update trigger for a table. You can use APPEND PROCEDURES and MODIFY PROCEDURES to create stored procedures that are executed when a Delete, Insert, or Update trigger occurs.
_TRIGGERLEVEL contains a numeric value that is read-only. If you use STORE or = to assign a value to _TRIGGERLEVEL, the value is ignored.