solidDB Help : solidDB reference : SQL: Statements : POST EVENT
  
POST EVENT
POST EVENT event‑name [( parameters)] [UNIQUE | DATA UNIQUE]
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.
For more details, see CREATE PROCEDURE
Example
--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";
Go up to
SQL: Statements