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.
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.  




Feedback | Notices


Timestamp icon Last updated: Tuesday, 27 September 2016


https://www.ibm.com/support/knowledgecenter/en/SS3LC4_7.5.3/com.ibm.wci.doc/conn_ref_Oracle,_DB2,_and_Informix_Parameters.html