Note You can use the WAIT EVENT statement only inside stored procedures. For more details, see CREATE PROCEDURE.
Access requirements
Database user
Usage
In a stored procedure, use the WAIT EVENT statement to make the procedure wait for an event to happen.
You can use WAIT EVENT with both system-defined events and user-defined events.
Example
WAIT EVENT -- When the event named "event1" is received... WHEN event1 BEGIN eventresult := 'event1'; -- Insert a record into the event_records table showing that -- this event was posted and received. EXEC SQL PREPARE call_cursor CALL insert_a_record(?); EXEC SQL EXECUTE call_cursor USING (eventresult); EXEC SQL CLOSE call_cursor; EXEC SQL DROP call_cursor; RETURN; END EVENT