Restrictions and limitations
The Database Interface Designer and database adapters offer options and functions for accessing and manipulating data contained within a database. However, there are some restrictions and limitations for the following functions when using certain adapters:
- Database triggers: Using a data source as an input event trigger.
- Bind facility: Using bind values in database functions.
- Stored procedures: Using stored procedures to access adapter commands and return values from stored functions.
The following table indicates the functions that are not supported by a specific adapter. The Oracle adapters support all functions.
Database-specific Adapter | Triggers | Bind Facility | Stored Procedures |
---|---|---|---|
DB2® (Windows/Linux) | NO | ||
Informix® | NO | ||
Microsoft™ SQL Server | NO | ||
ODBC | NO | ||
OLE DB | NO | NO | |
Sybase SQL Server | NO | NO |