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.

Related topics

Output-format

Operational-considerations

  • 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.

 

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