Alphabetical list of functions
336
Condition name Units Valid for… Comment
LogSize Megabytes GrowLog
RemainingValues Integer GlobalAutoincrement The number of
remaining values.
TempFreePercent N/A TempDiskSpace
TempFreeSpace Megabytes TempDiskSpace
TempSize Megabytes GrowTemp
The following event definition uses the event_condition function:
create event LogNotifier
type LogDiskSpace
where event_condition( ’LogDiskSpacePercentFree’ ) < 50
handler
begin
message ’LogNotifier message’
end
♦ SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise.
"CREATE EVENT statement" on page 435
EVENT_CONDITION_NAME function [System]
Can be used to list the possible parameters for EVENT_CONDITION.
EVENT_CONDITION_NAME (
integer
)
integer Must be greater than or equal to zero.
You can use EVENT_CONDITION_NAME to obtain a list of all
EVENT_CONDITION arguments by looping over integers until the function
returns NULL.
♦
SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise.
"CREATE EVENT statement" on page 435
EVENT_PARAMETER function [System]
Provides context information for event handlers.
Examples
Standards and
compatibility
See also
Function
Syntax
Parameters
Usage
Standards and
compatibility
See also
Function