TSFMT

The TSFMT option allows you to override the default Db2 external timestamp format.

Related topics

BMC AMI Unload option descriptions

UNLOAD-syntax-diagrams

UNLD-TSFMT 

GUID-379C5F8C-4B62-4445-B393-E07E8A44B6CB-low.png

Important

There is no corresponding +TSFMT parameter in the ULDPARMS.

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 timestamp format elements. Valid values are

  • DD for day
  • MM or MO for month
  • YY or YYYY for year
  • HH for hour
  • MM or MI for minute
  • SS for second
  • NN, NNNN, or NNNNNN for microsecond
  • 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.

Requirements

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

  • The string must begin with one of the valid timestamp 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:

  • You can specify MM for both months and minutes within one TSFMT option. BMC AMI Unload determines whether MM designates months or minutes based on the position of MM within the string. If BMC AMI Unload cannot determine whether MM designates months or minutes within the format, BMC AMI Unload terminates.
  • 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*