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 are in external format.

Important

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

Related topics

Output-format

Operational-considerations

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.

 

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