Sybase Adaptive Server Anywhere - Page 355

Chapter 8 SQL Functions
337
EVENT_PARAMETER ( context-name )
context-name :
’ConnectionID’
| ’User’
| ’EventName’
| ’Executions’
| ’NumActive’
| ’TableName’
|
condition-name
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.
♦
SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise.
"EVENT_CONDITION function" on page 335
"CREATE EVENT statement" on page 435
EXP function [Numeric]
Returns the exponential function, e to the power of a number.
EXP ( numeric-expression )
numeric-expression The exponent.
The statement returns the value 3269017.372.
SELECT EXP( 15 )
♦ SQL/92 Vendor extension.
Syntax
Parameters
Standards and
compatibility
See also
Function
Syntax
Parameters
Examples
Standards and
compatibility