We have moved to www.dataGenX.net, Keep Learning with us.

Thursday, December 13, 2012

DataStage Environment variables




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 


till then.....
njoy the simplicity.......