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 internal date and time (FORMAT INTERNAL)

To produce an output file in which all of the unloaded data is in internal format, specify FORMAT INTERNAL.

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 are the same as those of the source Db2 subsystem and application programs can process dates in internal Db2 format.

  • You are unloading LOB or XML data.

    Important

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

RestrictionIf you specify USELRECL YES with FORMAT INTERNAL, UNLOAD PLUS ignores USELRECL YES.

Related topics

Output-format

Operational-considerations

 

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