Use the OUTPUT clause to define the options for the Optim™ High Performance Unload output file without using the template keywords
feature.
Attention: The OUTPUT clause is supported for backward compatibility only.
Use the OUTFILE clause in all new control files.
- OUTPUT
- Use the OUTPUT keyword to begin the output file clause. If you use the
output_file_clause, you should specify a filename.
Attention: If the output is not
specified and there is only one output being generated, the output data goes to standard output
stream (stdout). Otherwise, OUTPUT is required.
- Syntax
OUTPUT ON CURRENT HOST | ON REMOTE HOST | ON "hostname" HOST
| ("directory_name") | "filename" REPLACE | APPEND FOR PARTS
clause-
- Use the ON CURRENT HOST option to unload table data to one or more output files
on the current node. The current node is the physical node where you submitted the
db2hpu command.
- Use the ON REMOTE HOST option to unload table data to one or more output files on the host on which the database partition resides. For this option, one file is generated for each database partition. Each file will use the output_file_clause filename and a qualifier (filename.nnn) which will be the number of that unloaded database partition. This option requires less network activity and is typically faster. In the case of multiple database partitions on a single Db2® node, the result will be that the database partitions will be unloaded to individually-identified files.
- The ON hostname HOST option will create the file on the specified host name
identified by hostname.
- Variable
- None.
- Default
- None.