Note You can use the POST EVENT statement only inside stored procedures. For more details, see CREATE PROCEDURE.
Access requirements
Database user
Usage
In a stored procedure, use the POST EVENT statement to post user-defined or system events.
Parameters, clauses, keywords, and variables
▪ UNIQUE: Specifies that only the last post for each event is kept in the event queue for each user. For example after POST EVENT EV(1) and POST EVENT EV(2) only EV(2) is in event queue (even if EV(1) is not processed before EV(2) is posted); event EV(1) is discarded.
▪ DATA UNIQUE: Specifies that only the last post for each event (with unique parameters) is kept in the event queue for each user. So after calls POST EVENT EV(1), POST EVENT EV(2) and POST EVENT EV(2) events EV(1) and EV(2) are kept in event queue; the first EV(2) is discarded.
--Create a stored procedure to post the event. "CREATE PROCEDURE post_event3(param INTEGER, s CHAR(4)) BEGIN -- Post the event. POST EVENT event3(param, s); END";