UNLD TIMEFMT

Use this option to override the ULDPARMS parameter for the current unload statement only.

This option enables BMC AMI Unload to generate a variety of time formats other than the standard Db2 formats.

Specify a string of up to 40 characters as an argument for TIMEFMT. BMC AMI Unload replaces character strings to generate the actual time in the formats shown in the following table:

Related topics

Option descriptions—UNLD syntax
UNLD-syntax-diagrams
ULDPARMS
 

Time formats

Character string

Time format

HH

Current hour, in either 12-hour or 24-hour format.

MM

Minutes elapsed from the top of the hour.

SS

Seconds elapsed from the start of the current minute.

XM

AM or PM, depending on whether the current time is before or after noon.

If XM appears, BMC AMI Unload replaces HH with an hour from a 12-hour clock (00-12); if XM does not appear, BMC AMI Unload replaces HHH with an hour from a 24-hour clock (00-24).

The time element can occur only once, and the entire string must contain at least one time element.

Example

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



 

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