Data Transformation Engine Resource Adapter Reference Guide

Chapter 5 - Database-specific Adapter Information Overview

Resource Adapters Reference Guide

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 Event Server

♦ 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 those functions not supported by specific adapter:

Database-specific Adapter

Triggers

Bind

Facility

Stored

Procedures

DB2 (MVS) NO NO NO

DB2 (MVS(CLI)) NO

DB2 (Windows/UNIX) NO

Informix NO

Microsoft SQL Server 6.5 NO NO

Microsoft SQL Server NO

ODBC NO

OLE DB NO NO

Sybase SQL Server NO NO

Note The Oracle adapters support all functions and do not have restrictions or

limitations.