The Comma Separated Value tab displays
when you select the Comma Separated Value (CSV) file format for the
converted file. The options on this tab are described below.
- Default Thresholds
- File Size (MB)
- Specify the maximum size of the converted file. Allowable values
are 1 to 9,99,999,999,999. The default is 5 MB.
- Row Count
- Maximum number of records to be written to converted file. If
this count is reached, a new file would be created. Specify a value
in the range 1 to 9,99,999,999,999. There is no default.
- Number of Files
- Maximum number files that can be created for a table or view.
Specify a value in the range 1 to 9,99,999,999,999. There is no default.
- Macro Options
- Use File Macro
- Select this check box to use a macro to create unique files for
each table shown in the grid.
- Macro:
- Specify the name of the Optim macro to be used to generate the
unique file names. For example: Specify the $OBJNAME macro to generate
a file name that includes the name of the table or view. For details
on using Optim macros to generate file names, refer to the Common
Elements Manual, Appendix A. Enhanced File Names.
- CSV Options
- Select this to display the following:
- Meta Data Options
- Generate Meta Data
- Selecting this check box writes the column names at the beginning
of the first record for a table. You can specify the following:
- Beginning Label:
- You can specify a label, up to 10 characters, to be prefixed before
the first column name.
- End Label:
- Specify a label, up to 10 characters, to be suffixed after the
last column name.
- Header Delimiter:
- Character to be used to separate column names. Specify 1 character.
The default is a dash (-).
- Field Delimiter
- This parameter is required. Specify 1 character to separate column
values. The default is a comma (,).
- Escape Character
- Specify a single character to be prepended to any string column
values. If you specify an Escape Character, Optim scans all character
data. There is no default.
Note: Use caution before specifying an Escape
Character, as scanning all character data imposes significant impact
on processing.
- String Delimiter
- Character to delimit string column values. There is no default.
- LOB/XML Options
- Include LOB/XML Columns
- Select this check box to have a separate file created for each
LOB or XML column in each row.
- LOB/XML Directory
- Fully qualified path to the directory for the LOB/XML column files
to be created. If the check box to Include LOB/XML Columns is
not selected, the LOB/XML Directory box is
unavailable.
- Null Field Options
- Use Null Field Value
- Select this check box to replace any column with a null value
with a string.
- Null Field Value
- Specify the string, up to 15 characters in length, to be used
as a replacement value for any column that has a null value.
- Grid
- This grid is populated only if a Table Map has been specified.
These columns are included:
- Object Name
- Names of the tables or views for the converted file. The values
in this column are the Destination Table Names from the Table Map
and cannot be modified.
- File Location
- Name of the unique file to be created for this table or view.
Specify:
- filename
- Name of the file to be created. If you do not specify a fully-qualified
path for the file, Optim creates a file with this name in the directory
specified on the Convert General tab for Destination File. If you
do not specify a file name, Optim creates a file with the name specified
on the Convert General tab for Destination File. If you specified
File Macros, Optim uses those macros to create unique files for all
empty columns in this grid.
- Row Count Per File Threshold
- Number of records to write to a file before creating a new file.
Allowable values are 1 to 9,99,999,999,999. If you do not supply a
value in this grid column, the value for Row Count, if specified,
is used.
- File Size
- Maximum file size (in MB) to write before creating a new file.
Allowable values are 1 to 9,99,999,999,999. If you do not specify
a value in this grid column, the value for File Size (MB), if specified,
is used.
- Number of Files
- Maximum number of files that can be created for a single table
or view. Allowable values are 1 to 9,99,999,999,999. If you do not
specify a value in this grid column, the value for Number of Files,
if specified, is used.