TSV Output Format Parameters
The TSV output format supports the following parameters:
| headers | ||
| Values: | ON | OFF | AUTO | |
| Default: | AUTO | |
| Description: | Write a header line containing the field names. | |
| Details: | This parameter controls the header line that is
output at the beginning of each file. The possible values for this parameter are:
|
|
| Example: | -headers:OFF | |
| oSeparator | ||
| Values: | any string | space | tab | |
| Default: | tab | |
| Description: | Separator between fields. | |
| Details: | This parameter controls the separator to be used
between field values. The "tab" keyword causes the TSV output format to use a single tab character between the fields, while the "space" keyword causes the TSV output format to use a single space character. |
|
| Example: | -oSeparator:space | |
| oTsFormat | ||
| Values: | timestamp format | |
| Default: | yyyy-MM-dd hh:mm:ss | |
| Description: | Format of timestamp values in the output TSV data. | |
| Details: | This parameter specifies the date and/or time format to
use when formatting values of the TIMESTAMP data type. For more information on date and time formats, see Timestamp Format Specifiers. |
|
| Example: | -oTsFormat:"MMM dd, yyyy" | |
| oCodepage | ||
| Values: | codepage ID (number) | |
| Default: | 0 | |
| Description: | Codepage of the output text. | |
| Details: | 0 is the system codepage, -1 is UNICODE. | |
| Example: | -oCodepage:1245 | |
| fileMode | ||
| Values: | 0 | 1 | 2 | |
| Default: | 1 | |
| Description: | Action to perform when an output file already exists. | |
| Details: | This parameter controls the behavior of the TSV
output format when the into-entity specifies directly
or indirectly through the "multiplex" feature the name of a file that already
exists. The possible values for this parameter are:
|
|
| Example: | -fileMode:0 | |