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.

TIMEFMT

The TIMEFMT option allows you to override the default Db2 external time format.

TIMEFMT.png

This option also overrides your Db2 time exit routine. This option is useful for porting unloaded data to other relational databases.

Restriction

UNLOAD PLUS ignores this option if you also specify FORMAT BMCLOAD.

('string')

This option allows you to specify a string of time format elements. Valid values are:

  • HH for hour
  • MM for minute
  • SS for second
  • XM for AM or PM

You can specify these values in any order and delimit them with any character or number, or any series of characters or numbers, although UNLOAD PLUS does not require a delimiter.

Requirements

The following requirements apply to the string that you specify with the TIMEFMT option:

  • The string must begin with one of the valid time format elements.
  • Only one occurrence of each value is valid.
  • If you specify this option, you must specify at least one value or the unload job terminates.

Additional considerations

The following considerations apply to this option:

  • If you specify XM, UNLOAD PLUS converts the HH element to a 12-hour format.
  • UNLOAD PLUS treats any other characters as constants in their specified position.

Related topic

Basic-processing-options

 

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