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.

Db2 output with external date and time (FORMAT STANDARD)

To produce an output file in which the unloaded data (except date, time, and timestamp data types) is in Db2 internal format, use FORMAT STANDARD (the default).

Date, time, and timestamp data is in external format.

Important

FORMAT STANDARD does not produce output that matches that of DSNTIAUL.

Use this option when either of the following conditions exists:

  • You plan to load the data into a Db2 subsystem where the date and time formats differ from those of the source Db2 subsystem and application programs require dates in a specified format.

  • You are unloading LOB or XML data.

    Important

    Alternatively, you can specify FORMAT INTERNAL to unload LOB or XML data.

Related topics

Output-format

Operational-considerations

 

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