External-formatted output (FORMAT EXTERNAL)


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

Use this option only when applications require data in this format, or when you are loading the data to a non-MVS target and you cannot use one of the other format options.

Warning

Important

You cannot use this option when you are unloading LOB or XML data. UNLOAD PLUS terminates in this case.

 

 

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

UNLOAD PLUS for DB2 13.1