Synonym Support for DB2 UDB
The following table lists the adapter services and notifications that support synonyms for a DB2 Universal Database (UDB).
Adapter Services | Adapter Notifications |
SelectSQL | Basic Notification |
DeleteSQL | Delete Notification |
InsertSQL | Insert Notification |
UpdateSQL | Ordered Notification |
| Update Notification |
Consider the following limitations when using synonyms with adapter services:
![*](chapterTOC_bullet.png)
The StoredProcedure and StoredProcedureWithSignature adapter services do not support synonyms because synonyms are treated as an alias table type in DB2 UDB. However, aliases cannot be created for stored procedures.
![*](chapterTOC_bullet.png)
The SelectSQL, DeleteSQL, InsertSQL, and Update SQL services support synonyms only for database tables and views.
For information about configuring adapter services, see
Overview of Adapter Services. For information about configuring adapter notifications, see
Overview of Adapter Notifications.