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_PARAMETERcontext-name )
context-name:
 'ConnectionID'
| 'User'
| 'EventName'
| 'Executions'
| 'IQDBMainSpaceName'
| 'NumActive'
| 'TableName'
| condition-name
Note: CIS functional compensation performance considerations apply.

Parameters

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.

Returns

VARCHAR

Standards and Compatibility

  • SQL—Vendor extension to ISO/ANSI SQL grammar.

  • Sybase—Not supported by Adaptive Server Enterprise.

Related reference
EVENT_CONDITION Function [System]