Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.
how can i use the notifications with views instead of tables. Tables can not be granted due to confidential information. thanks
We don’t support views with notifications. As the database trigger can’t be created with Views.
You can configure one Basic Notification. This notification doesn’t define any database trigger, the notification performs a regular polling to the database. I have one configured basic notification configured in an oracle DB and it’s working.