Creating Subscriptions to Change Views (Reference)

Go Up to Change Views (Reference)

To establish interest in observing changed data on a set of tables beyond the natural boundary of a database connection, a subscription must be created on a list of tables (base tables or views).

In creating subscriptions you would

Grant Subscribe: Grants the user subscribe privileges

Set Subscription: To set a subscription as active, an application issues a SET SUBSCRIPTION statement. The SET SUBSCRIPTION statement allows multiple subscriptions to be activated and includes an AT clause to denote a destination or device name as a recipient of subscribed changes. The subscriber user name is implied by the user identity of the database connection.

See Creating Subscriptions to Change Views or a complete explanation and examples of how to create subscriptions.