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 High-speed Apply Engine 13.1.

TimestampTzFormat

The TimestampTzFormat defines the default timestamp with time zone format that the High-speed Apply Engine uses when it updates timestamp columns in an Oracle target database.

Attributes

This parameter has the following attributes:

Attribute

Value

Section

[StartUp]

Abbreviation

None

DBMS

Oracle

Required?

No

Valid values

Any valid Oracle datetime format mask

For example:

'YYYY-MM-DD HH:MI:SS.FF TZH:TZM'

Default value

none

Usage

Specify a valid Oracle datetime format mask that matches the timestamps and time zones in your input.

Consider the following points regarding this parameter:

  • Use this parameter when your input was generated on a DBMS other than Oracle (or in a different Oracle environment) that uses a different timestamp with time zone format than the format of the timestamp columns in your target tables. When you specify this parameter, High-speed Apply Engine issues an ALTER SESSION SET statement to change the timestamp with time zone format (the nls_timestamp_tz_format parameter).
  • For valid datetime format masks, consult the Oracle DBMS technical documentation.
  • High-speed Apply Engine uses this parameter only when the target version of the Oracle DBMS is 9i or later. For earlier versions, High-speed Apply Engine ignores this parameter.

Related topic

StartUp-parameters

 

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