Fast Clone
- Fast Clone 10.0
- All Products
Field
| Description
| Default
|
---|---|---|
Column separator
| A character or character sequence that Fast Clone uses to separate columns in the output data files. Specify a character or character sequence that does not appear in the source data. Otherwise, the target load utility cannot correctly parse the data files. For more information, see
Selecting Column and Row Separator and Enclosure Character Using Sampling.
Fast Clone allows you to enter column separators that use the \x hh escape sequence in hexadecimal notation.
Also, you can use the following non-printable ASCII characters:
If you use non-printable characters as column separators, ensure that the target load utility supports these separators. For more information, see the target database documentation.
|
|
Record separator
| A character or character sequence that Fast Clone uses to separate table rows in the output data files. Specify a character or character sequence that does not appear in the source data. Otherwise, the target load utility cannot correctly parse the data files. For more information, see
Selecting Column and Row Separator and Enclosure Character Using Sampling.
Fast Clone allows you to enter row separators that use the \x hh escape sequence in hexadecimal notation.
Also, you can use the following non-printable ASCII characters:
If you use non-printable characters in row separators, ensure that the target load utility supports these separators. For more information, see target database documentation.
| \n
|
Enclosed by
| A character or character sequence that Fast Clone uses to enclose character data in the output data files. Specify a character or character sequence that does not appear in the source data. Otherwise, the target load utility cannot correctly parse the data files.
| Double-quotation mark (“)
|
Enclose numbers
| Indicates whether to enclose numeric data with the delimiter value that you specified in the
Enclosed by field.
| Not selected
|
Enclose dates
| Indicates whether to enclose DATE and TIMESTAMP data with the delimiter value that you specified in the
Enclosed by field.
| Not selected
|
Escape enclosure
| An escape character that Fast Clone inserts before the value that is specified in the
Enclosed by field whenever that value appears in data in text columns. If you enter an escape character, Fast Clone truncates the
Enclosed by value to a single character.
| Backslash (\)
|
Replace new line with space
| Indicates whether to replace the line break character (\n) with the space character in unloaded data. Select this option if you use the line break character as the
Record Separator value.
| Not selected
|
Replace any char with
| Click this button to define rules for replacing particular character sequences in the source data with another character sequence. For more information, see
Defining Rules for Character Sequence Replacement.
| -
|
Pad with blanks (fixed length)
| Select this option to unload data to output data files that use fixed-length record format. If the number of bytes of field data is less than the field length, Fast Clone pads the field on the right with the space characters.
| Not selected
|
Convert CLOBs from UTF16 into UTF8
| Select this option to convert character data in source CLOB columns from UTF-16 encoding to UTF-8 encoding when loading the data to output data files. If you do not use UTF-16 encoding for source character data, clear this option to avoid the overhead of character set conversion.
| Not selected
|
Convert numbers into packed decimal COMP3
| Indicates whether to write numeric data to the output files as COMP-3 values. Select this option if you need to read the output file with COBOL or another language that has built-in COMP-3 support.
| Not selected
|
COMP3 implied decimal
| The COMP-3 implied decimal value.
| 0
|
Convert output ASCII into EBCIDIC
| Select this option if you need the output to be in IBM EBCIDIC format.
| Not selected
|
Truncate numeric precision integer
| The number of significant digits that Fast Clone uses to round down the fractional part of numeric values in the output. Valid values are from 1 to 36.
You can override this value for individual source numeric columns. For more information, see
Specifying a Custom Format for a Column.
| No default
|
Unload binary into separate files
| Indicates whether to write data from BLOB, CLOB, NCLOB, LONG, and LONG RAW source columns to separate files. In the data files, Fast Clone includes the file name instead of the source value.
|
|
Trailing column separator
| Indicates whether to append a column separator after the last column in each table row in the output data files.
For Oracle targets, if you unload data from binary columns to separate files, Fast Clone does not append the trailing column separator after the last column if the datatype of that column is BLOB, CLOB, or XMLTYPE.
| Selected
|
Suppress trailing null columns
| Indicates whether to omit the last column value in the output data file if the column contains a null value.
If you use DataStreamer to load Greenpplum, Netezza, Teradata, or Vertica targets, clear this option.
| Selected
|
Timestamp format
| The format to use for timestamp values from TIMESTAMP source columns. For more information about valid TIMESTAMP formats, see the Oracle documentation.
You can override this format for individual TIMESTAMP columns. For more information, see
Specifying a Custom Format for a Column.
| YYYY-MM-DD HH24:MI:SS.FF6
|
Date format
| The format to use for date values from DATE source columns. For more information about valid DATE formats, see the Oracle documentation.
You can override this format for individual DATE columns. For more information, see
Specifying a Custom Format for a Column.
| YYYY-MM-DD HH24:MI:SS
|
Set local time zone
| Select this option to unload values from columns that have the TIMESTAMP WITH LOCAL TIMEZONE datatype. Then enter your local time zone offset.
| Not selected
|