|
|
|
Valid in: SQL, ESQL
The Create Dbevent statement creates the specified database event. Database events enable an application to pass status information to other applications. Event_name must be a valid object name. 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.
|
|
|
The Create Dbevent statement has the following format:
[EXEC SQL] CREATE DBEVENT [schema.]event_name
|
|
|
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.
|
|
|
All users are permitted to use this statement.
|
|
|
The Create Dbevent statement locks pages in the iievent catalog.
|
|
|