Oracle Support environment variables in DataStage

These environment variables are concerned with the interaction between DataStage® and Oracle databases.

APT_ORACLE_LOAD_OPTIONS environment variable in DataStage
Set the APT_ORACLE_LOAD_OPTIONS environment variable to control the options that are included in the Oracle load control file.
APT_ORACLE_PRESERVE_BLANKS environment variable in DataStage
Set the APT_ORACLE_PRESERVE_BLANKS environment variable to set the PRESERVE BLANKS option in the control file. This preserves leading and trailing spaces.
APT_ORA_IGNORE_CONFIG_FILE_PARALLELISM environment variable in DataStage
Set the APT_ORA_IGNORE_CONFIG_FILE_PARALLELISM environment variable to use the number of data files in the destination table's table space to determine the number of processing nodes available for a parallel write to Oracle.
APT_ORA_WRITE_FILES environment variable in DataStage
Set the APT_ORA_WRITE_FILES environment variable to prevent the invocation of the Oracle loader when write mode is selected on an Oracle Enterprise destination stage.
APT_ORAUPSERT_COMMIT_ROW_INTERVAL and APT_ORAUPSERT_COMMIT_TIME_INTERVAL environment variables in DataStage
Set these two environment variables to control how often target rows are committed when using the Upsert method to write to Oracle.

Parent topic: Environment variables in DataStage