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:

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