Output file formats


You can specify an output format using one of the FORMAT keyword operands shown in the following table:

Operands and output formats

Operand

Available with UNLOAD command

Available with UNLD command

Output format

DSNTIAUL

X

X

UNLOAD

X

X

DELIMITED


X

ASCIIDEL


X

EXTERNAL

X

X

With all output formats, you can unload all the columns or a subset of the columns.


 

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