Adapter for JDBC 10.3 | webMethods Adapter for JDBC Documentation | webMethods Adapter for JDBC Installation and User’s Documentation | Overview of the Adapter | Support for Synonyms | Synonym Support for DB2 UDB
 
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:
*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.
*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.