DATEFMT

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

GUID-96C63407-0E80-4483-BBD6-D4B4C283C525-low.png

Related topics

BMC AMI Unload option descriptions
BMC-AMI-Unload-Option-descriptions

UNLOAD-syntax-diagrams 

This option also overrides your Db2 date exit routine and the ULDPARMS DATEFMT parameter. You can use this option to port 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 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 BMC AMI Unload does not require a delimiter. BMC AMI Unload treats any other characters as constants in their specified position.

Example

If today is July 17, 2016, the character string YYYY.MM.DD results in the date format 2016.07.17.

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.



 

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