POST EVENT
Go Up to Procedures and Triggers
Posts an event. Available in triggers and stored procedures.
POST_EVENT 'event_name' | <col | variable>;
Argument | Description |
---|---|
<event_name> |
Name of the event being posted; must be enclosed in quotes |
col |
Name of a column whose value the posting will be based on |
variable |
Name of a string variable in the stored procedure or trigger |
Description: POST_EVENT
posts an event to the event manager. When an event occurs, this statement will notify the event manager, which alerts applications waiting for the named event.
Example: The following statement posts an event named “new_order”:
POST_EVENT 'new_order';
The next statement posts an event based on the current value of a column:
POST_EVENT NEW.COMPANY;
The next statement posts an event based on a string variable previously declared:
myval = 'new_order:' || NEW.COMPANY;
POST_EVENT myval;
See Also
For more information on events, see the Embedded SQL Guide.