IMPLICIT_TZ

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

Related topic

Basic processing options

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.

 

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