Access
The details below are displayed when the "Delimited ASCII files" option has been selected in the Data destination list in the data destination selection window of the Data copy tool.
This option is used to copy data into delimited ASCII files.
Data entry
File directory
Directory in which the data files are to be produced.
Enter the full path or click the Browse button to display a Windows system dialog box that lets you select a directory.
Mandatory entry.
Lists
Field delimiter
Character used to separate fields in the generated file.
String delimiter
Character used to separate string type values in the generated file.
Decimal symbol
Character used to represent the decimal point in the numerical values in the generated file.
Encoding
Destination file encoding (Ansi, Ascii or UTF-8).
Check boxes
ISO dates
Checked |
DATE type fields will be stored in ISO format. |
The tool recognizes two possible date formats:
Numerical |
YYYYMMDD format. |
ISO |
'YYYY-MM-DD' string. |
This behavior relates to the delimited ASCII format as specified in the DB2 documentation.
Default: Checked.
Fixed width
Checked |
Data will be exported into a text file of fixed width (no delimiters). |
Default: Not checked.
Buttons
Browse
This button opens a Windows system box that lets you select a directory.