Oracle, Sybase, DB2, and Informix Parameters

In the Additional Parameters table of the Database Endpoint, define the connection parameters for Oracle, Sybase, DB2, or Informix databases.

:

Oracle

If the Call Procedure activity calls an Oracle stored procedure that returns a result set, you must define an Endpoint solely for that connector and add the parameter procedureretresult. The value for this parameter must be 1.

If the Nchar or Nvarchar data types are used in a database activity that connects to an Oracle database, you must define the enablencharsupport parameter and assign it a value of 1 in the database Endpoint.

If an Oracle database table name starts with a number, Studio throws an Invalid Trigger Specification error.

If the project uses database links with the Oracle 8.1.6 database, you must define the supportLinks parameter and assign it a value of true in the Database Endpoint. By default, the MaxPooledStatements parameter is automatically defined and set with a default value for an Oracle Database Endpoint.   

DB2

For the DB2 database, you must define the following two parameters:

Note: The DB2 user must have the permissions to create a package.

By default, the MaxPooledStatements parameter is automatically defined and set with a default value for a DB2 Database Endpoint.

Informix

You must define the InformixServer parameter.

To find the Informix Server name search the onconfig file for DBSERVERNAME and specify its value for the InformixServer parameter.

By default, the MaxPooledStatements parameter is automatically defined and set with a default value for an Informix Database Endpoint.

Sybase

For a Sybase Endpoint, the OverwriteCharLimits parameter is automatically defined and set to the value of 32768. This parameter defines the size of character columns, for example: vchars and chars.

By default, the MaxPooledStatements parameter is automatically defined and set with a default value for a Sybase Database Endpoint.