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*