SQL Language Guide : 8. SQL Statements : REMOVE DBEVENT
 
Share this page                  
REMOVE DBEVENT
Valid in: SQL, ESQL, DBProc, OpenAPI, ODBC, JDBC, .NET
The REMOVE DBEVENT statement removes a database event for which an application has previously registered.
This statement has the following format:
[EXEC SQL] REMOVE DBEVENT [schema.]event_name;
The REMOVE DBEVENT statement specifies that an application no longer intends to receive the specified database event.
If the database event has been raised before the application removes the registration, the database event remains queued to the application and is received when the application issues the GET DBEVENT statement.
If the REMOVE DBEVENT statement is issued from within a transaction that is subsequently rolled back, the REMOVE DBEVENT statement is not rolled back. If an application issues the REMOVE DBEVENT statement for a database event for which it has not registered, the DBMS Server returns an error.
Permissions
This statement is available to all users.
Related Statements
REGISTER DBEVENT
CREATE DBEVENT
EXECUTE IMMEDIATE
IF - THEN - ELSE
PREPARE