EVENT_PARAMETER Function [System]

Provides context information for event handlers.

To define an event and its associated handler, use the CREATE EVENT statement.

See Reference: Statements and Options > SQL Statements > CREATE EVENT statement.

Syntax

EVENT_PARAMETER ( context-name )

context-name:
 'ConnectionID'
| 'User'
| 'EventName'
| 'Executions'
| 'IQDBMainSpaceName'
| 'NumActive'
| 'TableName'
| condition-name

Note: CIS functional compensation performance considerations apply.

Parameters
Parameter	Description
context-name	One of the preset strings. The strings are case-insensitive, and carry the following information:
ConnectionId	The connection ID, as returned by connection_property( 'id' )
User	The user ID for the user that caused the event to be triggered.
EventName	The name of the event that has been triggered.
Executions	The number of times the event handler has been executed.
NumActive	The number of active instances of an event handler. This is useful if you want to limit an event handler so that only one instance executes at any given time.
TableName	The name of the table, for use with RemainingValues.

In addition, you can access any of the valid condition-name arguments to the EVENT_CONDITION function from the EVENT_PARAMETER function.

VARCHAR