Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see UNLOAD PLUS for DB2 13.1.

DATEFMT

The DATEFMT option allows you to override the default Db2 external data format.

DATEFMT.png

This option also overrides your DB2 date exit routine. You can use this option to port 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 date format elements. Valid values are:

  • MM for month
  • DD for day
  • YY or YYYY for year

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. UNLOAD PLUS treats any other characters as constants in their specified position.

Requirements

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

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

Related topic

Basic-processing-options

 

 

 

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