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

1.4.2.2 DSNUTILB Configuration

  • Set DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE and TIMESTAMP WITH LOCAL TIME ZONE formats.
    • Environment "DSNUTILB_DATE_FORMAT" defines date format. If it is not set, use the default value "YYYY-MM-dd HH24:MI:SS".
    • Environment "DSNUTILB_TIMESTAMP_FORMAT" defines timestamp format. If it is not set, use the default value "YYYY-MM-DD-HH24.MI.SS.FF6".
    • Environment "DSNUTILB_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 "DSNUTILB_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".
  • Set DSNUTILB_CLEAN_TABLE.
    • Environment "DSNUTILB_CLEAN_TABLE" chooses the way to delete records in a table when REPLACE option is set for load process in DSNUTILB. Valid values are 1, 2, and 3. If it is not set or set incorrectly, use the default value 1.
      • 1: Use stored procedure. Batch runtime provides SQL script $JESDIR/util/DSNUTILBPKG.sql to create DSNUTILB_PKG package, which contains a procedure to truncate specific table.
      • 2: Use statement truncate.
      • 3: Use statement DELETE.
    • Set language and territory.

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

Parent topic: DSNUTILB