CREATE DBEVENT
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The CREATE DBEVENT statement defines a database event.
Syntax
The CREATE DBEVENT statement has the following format:
[EXEC SQL] CREATE DBEVENT [schema.]event_name
event_name
Identifies the event. The event_name must be a valid object name.
Description
The CREATE DBEVENT statement creates the specified database event. Database events enable an application to pass status information to other applications.
Database events can be registered or raised by any session, provided that the owner has granted the required permission (raise or register) to the session’s user, group, or role identifier, or to public. Only the user, group, or role that created a database event can drop that database event.
Usage in OpenAPI, ODBC, JDBC, .NET
In ODBC, JDBC, and .NET, events can be created in query statements, but other interfaces must be used to catch the event being created.
Permissions
This statement is available to all users.
Related Statements
DROP DBEVENT
GRANT (privilege)
RAISE DBEVENT
REGISTER DBEVENT
REMOVE DBEVENT
Last modified date: 10/30/2024