Example:
dataextract * from customer;
outfile clipboard
compress
The output option "compress" will cause the output to be made in compressed form; i.e., all column values are output in their actual length only. This output format is probably the one preferred or even the one required in most cases, e.g., for Word data files or data sources or for a correct interpretation of the data in Excel.
If the option "compress" is not used, the column values output will be filled with blanks up to full column width. Output of numeric values will be right justified.
The data will always be provided in tabular form within the clipboard, i.e., in RTF format and in text form with tabulators as field separators.
Note: The default values for DELIMITER and SEPARATOR (see the LOAD manual) valid for compressed file output have no effect for CLIPBOARD output. The usage of the options "delimiter" or "separator" is not allowed for output made to the clipboard.