CC_ORA_LOB_LOCATOR_COLUMNS

Set this environment variable to specify whether the connector uses OCI LOB locators when the connector writes data into LOB columns. For example, use this environment variable when you want to support SDO_GEOMETRY and XMLTYPE columns and functions.

Set this environment variable to a comma-delimited list of InfoSphere DataStage columns of LongVarchar, LongNVarchar, and LongVarBinary data types that you want to use OCI LOB locators to write data into their respective CLOB, NCLOB, or BLOB columns. Do not include columns that are defined by using the Oracle deprecated LONG or LONG RAW data types.

To use OCI LOB locators for all LongVarchar, LongNVarchar, and LongVarBinary columns, set this environment variable to (all). Use this value only if you are not using the Oracle deprecated LONG or LONG RAW data types.

When this environment variable is set to (none) or undefined, the connector does not use OCI LOB locators for any columns.