Default Data Type (or WIZARDDEFAULT SQLTYPE) 

The default data type used for all fields in the data source (you can change the default in subsequent steps).  

varchar 

numeric 

time 

timestamp 

Record Length (or WIZARDDEFAULT PRECISION) 

The maximum length of a record in number of characters. This option must be appropriate for the selected data type and must be the same for all fields. 

Any integer greater than or equal to 0. 

Field Count 

The number of fields per record. 

Any integer greater than 1. 

Default Precision 

The length of the database columns for each field. You can modify this value for each field at a later time. 

For numeric data types, enter <= 38. 

For time/timestamp data types, enter the length of the format. 

Type of XML File 

An indicator of whether the XML file is read/write or read only. 

READWRITE 

READONLY 

ROWNAME 

Record Delimiter 

The character that separates each record. 

newline (LF) 

carriage return (CR) 

CR LF 

CR LF or LF 

semicolon (;) 

comma (,) 

tab 

pipe (|) 

Field Delimiter 

The character that separates each field in a record. Select User Defined if the character does not match any of the other options in the menu. 

comma 

tab 

semicolon 

pipe 

User Defined 

User-defined Field Delimiter 

The custom character that separates each field in a record. Use this field to specify a delimiter that is not a comma, tab, semicolon, or pipe. Unless you select User Defined for the Field Delimiter, this field is ignored. 

Text Qualifier 

A qualifier used to indicate text. 

none 

double quote: “ 

single quote: ” 

First line contains field names? 

An indicator of whether the names specified in the header row are used as field names or whether Data Integrator should assign default field names. 

Select the check box to use column header names from the file. Deselect the check box if the file does not contain a header row. 

Create data file if not exist? 

Header Offset 

The number of bytes to skip before reaching the start of the first record. This value is ignored if the First line contains field names? check box is deselected. 

Any integer greater than or equal to 0. 

Rows to Skip (or Records to Skip) 

The number of rows or records to skip before the starting row or record for the data set. Specify 0 (zero) to include all rows or records from the source. 

Any integer greater than or equal to 0. 

Maximum # of Faults to Tolerate 

The number of faults that can occur before Data Integrator generates an error message. 

Any integer greater than or equal to 0. 

Trim Whitespace 

An indicator of whether to strip white space and tabs from the beginning and end of a string. 

Select the check box to trim white space. Deselect the check box to leave white space in the string.