Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

EVENT_CONDITION function [System]

Specifies 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:

The EVENT_CONDITION function returns NULL when not called from an event.

• CREATE EVENT statement

• SQL/2003    Vendor extension.

The following event definition uses the EVENT_CONDITION function:

CREATE EVENT LogNotifier
TYPE LogDiskSpace
WHERE event_condition( 'LogFreePercent' ) < 50
HANDLER
BEGIN
   MESSAGE 'LogNotifier message'
END;