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.