TSFMT

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

• DD for day
• MM or MO for the month
• YY or YYYY for the year
• HH for hour
• MM or MI for a minute
• SS for second
• NN, NNNN, or NNNNNN for a 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 UNLOAD PLUS 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. UNLOAD PLUS determines whether MM designates months or minutes based on the position of MM within the string. If UNLOAD PLUS cannot determine whether MM designates months or minutes within the format, UNLOAD PLUS terminates.
• 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.