Contents Index SYSTEM statement [Interactive SQL] TRUNCATE TABLE statement

ASA SQL Reference
  SQL Statements

TRIGGER EVENT statement


Description 

Use this statement to trigger a named event. The event may be defined for event triggers or be a scheduled event.

Syntax 

TRIGGER EVENT event-name [ ( parm = value, ... ) ]

Parameters 

parm = value    When a triggering condition causes an event handler to execute, the database server can provide context information to the event handler using the event_parameter function. The TRIGGER EVENT statement allows you to explicitly supply these parameters, in order to simulate a context for the event handler.

Usage 

Actions are tied to particular trigger conditions or schedules by a CREATE EVENT statement. You can use the TRIGGER EVENT statement to force the event handler to execute, even when the scheduled time or trigger condition has not occurred. TRIGGER EVENT does not execute disabled event handlers.

Permissions 

Must have DBA authority.

Side effects 

None.

See also 

ALTER EVENT statement

CREATE EVENT statement

EVENT_PARAMETER function [System]

Example 

Add the following message to the engine window output:'ev_PassedParameter - was trigger at: ' + event_parameter('Time');

CREATE EVENT ev_PassedParameter
HANDLER
BEGIN
END;
TRIGGER EVENT ev_PassedParameter("Time"=string(current timestamp));

Contents Index SYSTEM statement [Interactive SQL] TRUNCATE TABLE statement