XML tab for an XML formatted file

When you select XML as the file format for the converted file, the XML tab displays.

Example of the XML tab, described as follows.
Default Thresholds
Define default thresholds for the converted files.
File Size (MB)
Specify the maximum size of the converted file. Allowable values are 1 - 999,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 - 999,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 - 999,999,999,999. There is no default.
Macro Options
Use a file macro to create unique files names for each table that is shown in the object grid.
Use File Macro
Select this check box to use a macro to create unique files for each table that is 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.
Example of the XML Options tab, described as follows.
XML Options
Click to open the XML Options dialog and enter processing options for the converted files.
Null Field Options
Use Null Field Value
Select this check box if you want to specify a string value to be written into any column whose value is null.
Null Field Value
Specify a 1-15 character ASCII string to be written into any column whose value is null.
LOB/XML Options
Include LOB/XML Columns
Select this check box to create a separate file 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.
Object Grid
Use the grid to specify object-specific target files and thresholds. The grid is populated only if a Table Map is specified.
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, a file is created with this name. The file is created in the directory that is specified for the Destination File on the General tab of the Convert Request Editor. If you do not specify a file name, a file is created with the name specified for the Destination File on the General tab. If you specified File Macros, those macros are used 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 a new file is created. Allowable values are 1 - 999,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 a new file is created. Allowable values are 1 - 999,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 - 999,999,999,999. If you do not specify a value in this grid column, the value in the Default Thresholds area for Number of Files is used, if specified.


Feedback