+TIMEFMT

Use this parameter to set or override the BMC AMI Unload default time format when running DIRECT YES. If running DIRECT NO and you want to change the Db2 default time format use the TIMEFMT keyword on the UNLOAD statement. 

The distributed default is DECP. This default affects only the external representation of date values when using any format except UNLOAD.


Related topics

BMC-AMI-Unload-parameters-ULDPARMS-DD

TIMEFMT (UNLOAD syntax)

UNLD-TIMEFMT 

TIMEFMT.png

Operands

ISO

(Default) Uses the ISO time format

EUR

Uses the European time format

JIS

Uses the Japanese Industrial Standard time format

USA

Uses the USA time format

DECP

Uses the standard time format as defined in DSNHDECP

Example
+TIMEFMT(ISO)

BMC AMI Unload sets the default format to ISO.

Important

For the rules that apply to parameter syntax, see Parameter syntax rules.

 

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