The mi_trigger_level() function
The mi_trigger_level() function returns the nesting level value of the current trigger.
Syntax
mi_integer mi_trigger_level(void) | Valid in client LIBMI application? | Valid in user-defined routine? |
|---|---|
| No | Yes |
Usage
The mi_trigger_level() function returns the nesting level of the current trigger. The values returned begin at 1 and increment by 1 for each nesting level, with a maximum of 61 levels. This function can be called in SPL trigger functions and trigger procedures only within the triggered action list of the FOR EACH ROW clause in trigger definitions.
Return values
- 0
- The UDR is currently not executing as a part of trigger action.
- 1-61
- The value of the nesting level of the current trigger.