Comma Separated Value Tab - for Comma Separated Value (CSV) File

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.

Comma Separated Values tab, options described following
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:
Comma Separated Value Options, described in the following text
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.