The ADMIN EVENT statement is a solidDB®-specific extension to SQL that allows you to register for and wait for system-generated events without writing and calling a stored procedure. You cannot wait for user events using ADMIN EVENT. If you want to wait for user events, you must write and call a stored procedure.
When using events outside stored procedures, you must register for and wait for the event explicitly. You must register for the event before you wait for it.
Tip: The ADMIN EVENT works differently from the way that WAIT works in stored procedures. In stored procedures, explicit registration is optional.
▪You cannot register to synchronization events (starting with “SYNC_”) with this command, because the ADMIN EVENT 'wait' command is not able to return variable result sets. Instead, you must use stored procedures to handle synchronization events.
▪Once the connection starts to wait for an event, the connection will not be able to do anything else until the event is posted.
▪You may register for multiple events. When you wait, you cannot specify which type of event to wait for. The wait will continue until you have received any of the events for which you have registered.
▪The ADMIN EVENT command does not provide an option to post an event.
▪To use ADMIN EVENT, you must have administrator privileges or be granted the role SYS_ADMIN_ROLE.