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 for the Launcher.
  • 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® (z/OS®) NO NO NO
DB2 (z/OS ODBC) NO    
DB2 (Windows/UNIX) NO    
Informix® NO    
Microsoft SQL Server   NO  
ODBC NO    
OLE DB NO NO  
Sybase SQL Server NO NO