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