EVENT_PARAMETER function [System]

Function

Provides context information for event handlers.

Syntax

EVENT_PARAMETER ( context-name )

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

CIS functional compensation performance considerations apply. See “Conditions that cause processing by SQL Anywhere” in Chapter 3, “Optimizing Queries and Deletions,” in the Performance and Tuning Guide.

Parameters

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.

Standards and compatibility

SQL Vendor extension to ISO/ANSI SQL grammar.

Sybase Not supported by Adaptive Server Enterprise

See also

“EVENT_CONDITION function [System]”

CREATE EVENT statement in Reference: Statements and Options