May 12, 2014 \ Ananth TM DataStage Environment variables list 1 Buffering 2 Building Custom stages 1.1 APT_BUFFER_FREE_RUN 2.1 DS_OPERATOR_BUILDOP_DIR 1.2 APT_BUFFER_MAXIMUM_MEMORY 2.2 OSH_BUILDOP_CODE 1.3 APT_BUFFER_MAXIMUM_TIMEOUT 2.3 OSH_BUILDOP_HEADER 1.4 APT_BUFFER_DISK_WRITE_INCREMENT 2.4 OSH_BUILDOP_OBJECT 1.5 APT_BUFFERING_POLICY 2.5 OSH_BUILDOP_XLC_BIN 1.6 APT_SHARED_MEMORY_BUFFERS 2.6 OSH_CBUILDOP_XLC_BIN 3 Compiler 4 DB2 Support 3.1 APT_COMPILER 4.1 APT_DB2INSTANCE_HOME 3.2 APT_COMPILEOPT 4.2 APT_DB2READ_LOCK_TABLE 3.3 APT_LINKER 4.3 APT_DBNAME 3.4 APT_LINKOPT 4.4 APT_RDBMS_COMMIT_ROWS 4.5 DB2DBDFT 5 Debugging 5.1 APT_DEBUG_OPERATOR 6 Decimal Support 5.2 APT_DEBUG_MODULE_NAMES 6.1 APT_DECIMAL_INTERM_PRECISION 5.3 APT_DEBUG_PARTITION 6.2 APT_DECIMAL_INTERM_SCALE 5.4 APT_DEBUG_SIGNALS 6.3 APT_DECIMAL_INTERM_ROUND_MODE 5.5 APT_DEBUG_STEP 5.6 APT_DEBUG_SUBPROC 7 Disk IO 5.7 APT_EXECUTION_MODE 7.1 APT_BUFFER_DISK_WRITE_INCREMENT 5.8 APT_PM_DBX 7.2 APT_CONSISTENT_BUFFERIO_SIZE 5.9 APT_PM_GDB 7.3 APT_EXPORT_FLUSH_COUNT 5.10 APT_PM_SHOW_PIDS 7.4 APT_IO_MAP/APT_IO_NOMAP and APT_BUFFERIO_MAP/APT_BUFFERIO_NOMAP 5.11 APT_PM_XLDB 7.5 APT_PHYSICAL_DATASET_BLOCK_SIZE 5.12 APT_PM_XTERM 5.13 APT_SHOW_LIBLOAD 9 Job Monitoring 9.1 APT_MONITOR_SIZE 8 General Job Admin 9.2 APT_MONITOR_TIME 8.1 APT_CHECKPOINT_DIR 9.3 APT_NO_JOBMON 8.2 APT_CLOBBER_OUTPUT 9.4 APT_PERFORMANCE_DATA 8.3 APT_CONFIG_FILE 8.4 APT_DISABLE_COMBINATION 11 Lookup 8.5 APT_EXECUTION_MODE 11.1 APT_LUTCREATE_NO_MMAP 8.6 APT_ORCHHOME 8.7 APT_STARTUP_SCRIPT 12 Network 8.8 APT_NO_STARTUP_SCRIPT 12.1 APT_IO_MAXIMUM_OUTSTANDING 8.9 APT_STARTUP_STATUS 12.2 APT_IOMGR_CONNECT_ATTEMPTS 8.10 APT_THIN_SCORE 12.3 APT_PM_CONDUCTOR_HOSTNAME 12.4 APT_PM_NO_TCPIP 10 Misc 12.5 APT_PM_NODE_TIMEOUT 10.1 APT_COPY_TRANSFORM_OPERATOR 12.6 APT_PM_SHOWRSH 10.2 “APT_EBCDIC_VERSION” on page 65 12.7 APT_PM_USE_RSH_LOCALLY 10.3 APT_DATE_CENTURY_BREAK_YEAR 12.8 APT_RECVBUFSIZE 10.4 APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL 12.9 APT_RECVBUFSIZE 10.5 APT_IMPORT_REJECT_STRING_FIELD_OVERRUNS 10.6 APT_INSERT_COPY_BEFORE_MODIFY 13 NLS 10.7 APT_OLD_BOUNDED_LENGTH 13.1 APT_COLLATION_SEQUENCE 10.8 APT_OPERATOR_REGISTRY_PATH 13.2 APT_COLLATION_STRENGTH 10.9 APT_PM_NO_SHARED_MEMORY 13.3 APT_ENGLISH_MESSAGES 10.10 APT_PM_NO_NAMED_PIPES 13.4 APT_IMPEXP_CHARSET 10.11 APT_PM_SOFT_KILL_WAIT 13.5 APT_INPUT_CHARSET 10.12 APT_PM_STARTUP_CONCURRENCY 13.6 APT_OS_CHARSET 10.13 APT_RECORD_COUNTS 13.7 APT_OUTPUT_CHARSET 10.14 APT_SAVE_SCORE 13.8 APT_STRING_CHARSET 10.15 APT_SHOW_COMPONENT_CALLS 10.16 APT_STACK_TRACE 14 Oracle Support 10.17 APT_WRITE_DS_VERSION 14.1 APT_ORACLE_LOAD_DELIMITED 10.18 OSH_PRELOAD_LIBS 14.2 APT_ORACLE_LOAD_OPTIONS 14.3 APT_ORACLE_NO_OPS 15 Partitioning 14.4 APT_ORACLE_PRESERVE_BLANKS 15.1 APT_NO_PART_INSERTION 14.5 APT_ORA_IGNORE_CONFIG_FILE_PARALLELISM 15.2 APT_PARTITION_COUNT 14.6 APT_ORA_WRITE_FILES 15.3 APT_PARTITION_NUMBER 14.7 APT_ORAUPSERT_COMMIT_ROW_INTERVAL APT_ORAUPSERT_COMMIT_TIME_INTERVAL 16 Reading/Writing files 17 Reporting 16.1 APT_DELIMITED_READ_SIZE 17.1 APT_DUMP_SCORE 16.2 APT_FILE_IMPORT_BUFFER_SIZE 17.2 APT_ERROR_CONFIGURATION 16.3 APT_FILE_EXPORT_BUFFER_SIZE 17.3 APT_MSG_FILELINE 16.4 APT_IMPORT_PATTERN_USES_FILESET 17.4 APT_PM_PLAYER_MEMORY 16.5 APT_MAX_DELIMITED_READ_SIZE 17.5 APT_PM_PLAYER_TIMING 16.6 APT_PREVIOUS_FINAL_DELIMITER_COMPATIBLE 17.6 APT_RECORD_COUNTS 16.7 APT_STRING_PADCHAR 17.7 OSH_DUMP 17.8 OSH_ECHO 18 Sorting 17.9 OSH_EXPLAIN 18.1 APT_NO_SORT_INSERTION 17.10 OSH_PRINT_SCHEMAS 18.2 APT_SORT_INSERTION_CHECK_ONLY 21 SAS Support 19 Teradata Support 21.1 APT_HASH_TO_SASHASH 19.1 APT_TERA_64K_BUFFERS 21.2 APT_NO_SASOUT_INSERT 19.2 APT_TERA_NO_ERR_CLEANUP 21.3 APT_NO_SAS_TRANSFORMS 19.3 APT_TERA_NO_PERM_CHECKS 21.4 APT_SAS_ACCEPT_ERROR 19.4 APT_TERA_NO_SQL_CONVERSION 21.5 APT_SAS_CHARSET 19.5 APT_TERA_SYNC_DATABASE 21.6 APT_SAS_CHARSET_ABORT 19.6 APT_TERA_SYNC_USER 21.7 APT_SAS_COMMAND 21.8 APT_SASINT_COMMAND 20 Transport Blocks 21.9 APT_SAS_DEBUG 20.1 APT_AUTO_TRANSPORT_BLOCK_SIZE 21.10 APT_SAS_DEBUG_IO 20.2 APT_LATENCY_COEFFICIENT 21.11 APT_SAS_DEBUG_LEVEL 20.3 APT_DEFAULT_TRANSPORT_BLOCK_SIZE 21.12 APT_SAS_DEBUG_VERBOSE 20.4 APT_MAX_TRANSPORT_BLOCK_SIZE/ APT_MIN_TRANSPORT_BLOCK_SIZE 21.13 APT_SAS_NO_PSDS_USTRING 21.14 APT_SAS_S_ARGUMENT 21.15 APT_SAS_SCHEMASOURCE_DUMP 21.16 APT_SAS_SHOW_INFO 21.17 APT_SAS_TRUNCATION