|
|
|
Valid in: SQL, ESQL, DBProc
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.
|
|
|
The Remove Dbevent statement has the following format:
[EXEC SQL] REMOVE DBEVENT [schema.]event_name;
|
|
|
All users are permitted to use this statement.
|
|
|