Sybase Adaptive Server Anywhere - Page 353

Chapter 8 SQL Functions
335
ESTIMATE_SOURCE returns one of the following strings:
♦ Column
♦ Guess
♦ Index
♦ Value
The following statement returns the value Index.
SELECT DISTINCT ESTIMATE_SOURCE( emp_id, 200, ’>’ )
FROM employee
♦ SQL/92 Vendor extension.
♦
Sybase Not supported by Adaptive Server Enterprise.
"Query Optimization" on page 835 of the book ASA User’s Guide
EVENT_CONDITION function [System]
To specify when an event handler is triggered.
EVENT_CONDITION ( condition-name )
condition-name The condition triggering the event. The possible values
are preset in the database, and are case insensitive. Each condition is valid
only for certain event types. The conditions and the events for which they are
valid are as follows:
Condition name Units Valid for… Comment
DBFreePercent N/A DBDiskSpace
DBFreeSpace Megabytes DBDiskSpace
DBSize Megabytes GrowDB
ErrorNumber N/A RAISERROR
IdleTime Seconds ServerIdle
Interval Seconds All Time since handler last
executed
LogFreePercent N/A LogDiskSpace
LogFreeSpace Megabytes LogDiskSpace
Return value
Examples
Standards and
compatibility
See also
Function
Syntax
Parameters