CREATE DBEVENT
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The CREATE DBEVENT statement defines a database event.
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.
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.
Embedded Usage
In an embedded CREATE DBEVENT statement, event_name cannot be specified using a host language variable. Event_name can be specified as the target of a dynamic SQL statement string.
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.
Locking
The CREATE DBEVENT statement locks pages in the iievent catalog.
Related Statements
DROP DBEVENT
GRANT (privilege)
RAISE DBEVENT
REGISTER DBEVENT
REMOVE DBEVENT
Last modified date: 11/09/2022