Output format
You can use the FORMAT option to specify the format of your output data.
The following table briefly describes the keywords of the FORMAT option so that you can quickly compare the types of formats and determine which format best meets your needs.
Keyword | Description | Reference |
|---|---|---|
STANDARD | Provides output data in Db2 internal format except date, time, and timestamp data types, which are in external format This is the default for the FORMAT option. | |
EXTERNAL | Provides all output data in external format This output enables porting to other databases and applications, but might not be as optimal as the other options. | |
INTERNAL | Provides all output data in Db2 internal format | |
BMCLOAD | Provides data in an internal format that only LOADPLUS can use This internal format is a high-speed migration solution for Db2 data. | |
DSNTIAUL | Provides output data that matches the output of the IBM DSNTIAUL program | |
CSV | Provides output data in comma-separated-value form This output enables porting to other databases and applications. | |
XML | Provides output data in which each field is enclosed by XML tags This output enables porting to other databases and applications. |
The topics that follow describe how to use UNLOAD PLUS to unload data in specific formats. For additional information, see the following references:
- For examples, see Examples-of-FORMAT-option-output.
- For the FORMAT option, see FORMAT.
- For performance information, see Specifying-command-options-for-optimal-performance.