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 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:
- LocationName - Enter the location name defined during installation for the AS/400 DB2 database. Not required for UDB.
- PackageCollection - The value of this field
depends on the system type of the DB2 database:
- AS/400 - Enter the collection name.
- UDB - Enter the name of the DB2 Database.
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.