Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see UNLOAD PLUS for DB2 13.1.

IMPLICIT_TZ

The IMPLICIT_TZ option enables you to specify a time zone to use in certain situations.

IMPLICIT_TZ.png

UNLOAD PLUS uses this time zone for the following specifications:

  • You are unloading a TIMESTAMP column (without a time zone) and the field specification for the column is TIMESTAMP WITH TIME ZONE.
  • A SELECT statement has the following characteristics:
    • The field specification includes a TIMESTAMP WITH TIME ZONE field.
    • You are updating the field by specifying a timestamp constant that does not include a time zone.
  • A WHERE clause has the following characteristics:
    • The predicate is comparing values to a TIMESTAMP WITH TIME ZONE column.
    • You specify a constant that does not include a time zone.

UNLOAD PLUS adds the time zone that you specify to the timestamp value.

Specify a time zone, within quotation marks, as the difference between local time and Coordinated Universal Time (UTC). You can specify a value from -12:59 through +14:00. If you do not specify a value for the IMPLICIT_TZ option, UNLOAD PLUS uses the DSNHDECP IMPLICIT_TIMEZONE value.

Any time zone that you specify in a SELECT statement overrides the value of this option.

Related topic

Basic-processing-options

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*