ULRegisterForEvent method

Registers or unregisters a queue to receive notifications of an event.

Syntax

public ul_bool ULRegisterForEvent(
     SQLCA * sqlca,
    char const * event_name,
    char const * object_name,
    char const * queue_name,
    ul_bool register_not_unreg
)

Parameters

sqlca A pointer to the SQLCA.
event_name The system- or user-defined event to register for.
object_name The object to which the event applies, such as a table name.
queue_name The connection queue name. NULL denotes the default connection queue.
register_not_unreg True to register; false to unregister.

If no queue name is supplied, the default connection queue is implied, and created if required. Certain system events allow you to specify an object name to which the event applies. For example, the TableModified event can specify the table name. Unlike the ULSendNotification method, only the specific queue registered receives notifications of the event. Other queues with the same name on different connections do not receive notifications, unless they are also explicitly registered.

The predefined system events are:

TableModified Triggered when rows in a table are inserted, updated, or deleted. One notification is sent per request, no matter how many rows were affected by the request. The object_name parameter specifies the table to monitor. A value of "*" means all tables in the database. This event has a parameter named table_name whose value is the name of the modified table.
Commit Triggered after any commit completes. This event has no parameters.
SyncComplete Triggered after synchronization completes. This event has no parameters.

Discuter à propos de cette page dans DocCommentXchange.