TIMEFMT

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


Related topics

BMC AMI Unload option descriptions

UNLOAD-syntax-diagrams

UNLD-TIMEFMT 

TIMEFMT.png

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

Restriction

BMC AMI Unload ignores this option if you also specify FORMAT UNLOAD. 

'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 BMC AMI Unload does not require a delimiter.

Example

For a time of 3:14 in the afternoon, specifying the format string 'HH-MM(XM)' results in 3-14(PM).

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, BMC AMI Unload converts the HH element to a 12-hour format.
  • BMC AMI Unload treats any other characters as constants in their specified position.

 

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