1. Application Runtime for Batch Reference Guide
  2. Z/OS JCL in the Batch Runtime Environment
  3. DB2 Utilities
  4. DSNTIAUL
  5. DSNTIAUL Configuration

1.4.1.2 DSNTIAUL Configuration

Do the followings to configure Batch Runtime DSNTIAUL.

  1. Set up environment variables for your Batch Runtime.
  2. Enable Batch Runtime built-in DB2-to-Oracle SQL Converter.

    To enable it, you can either use export MT_DB_SQL_PREPROCESS="${JESDIR}/tools/sql/oracle/BatchSQLConverter.sh" or configure MT_DB_SQL_PREPROCESS in $JESDIR/ejr/CONF/BatchRT.conf.

  3. Configure MT_DSNTIAUL=Y

    The default value of MT_DSNTIAUL is "Y".

  4. Set DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE and TIMESTAMP WITH LOCAL TIME ZONE formats.
    • Environment "DSNTIAUL_DATE_FORMAT" defines date format. If it is not set, use the default value "YYYY-MM-dd HH24:MI:SS".
    • Environment "DSNTIAUL_TIMESTAMP_FORMAT" defines timestamp format. If it is not set, use the default value "YYYY-MM-DD-HH24.MI.SS.FF6".
    • Environment "DSNTIAUL_TIMESTAMP_TZ_FORMAT" defines timestamp with time zone format. If it is not set, use the default value "YYYY-MM-DD-HH24.MI.SS.FF6".
    • Environment "DSNTIAUL_TIMESTAMP_LTZ_FORMAT" defines timestamp with local time zone format. If it is not set, use the default value "YYYY-MM-DD-HH24.MI.SS.FF6".
  5. Set language and territory.

    Environment variable "NLS_LANG" defines language and territory. If it is not set, use the default value "American".

See Also:

For more information, see Setting Environment Variables in Oracle Tuxedo Application Runtime for Batch User Guide.

Parent topic: DSNTIAUL