Product specifications

Caution:
Only Probe Rows set to all allows the driver to find the longest string.
• column nullability
Nullability is true if there is a null value in the column, false if all values are filled.
Unless you select all rows, you choose the number of lines the driver has to analyze by setting the
Number of Probe Rows parameter in the connection wizard.
Note:
See the Information Design Tool User Guide for recommendations.
Use of DDL files
The data access driver first analyzes the DDL file to convert SQL data types into driver data types.
The DDL file follows this pattern:
ColumnName[:ColumnType[(Length)]];
For example:
col1:VARCHAR(20);
col2:DATE;
col3:INTEGER;
col4:INTEGER;
The DDL file can only define one table schema. The driver assigns the same schema to every CSV file
used as data source.
Use of SQLDDL files
The data access driver first analyzes the SQLDDL file to convert SQL data types into driver data types.
The SQLDDL file follows this pattern:
CREATE TABLE <csvFilename> (
(<ColumnName> <ColumnType> [NOT] NULL,)*
(<ColumnName> <ColumnType> [NOT] NULL)
);
For example:
CREATE TABLE Clients (
id INTEGER NOT NULL,
name CHAR(20) NULL,
date DATE NULL,
PRIMARY KEY (id) )
The SQLDDL file can define several table schemas. The driver can assign a schema to several tables.
The data access driver analyzes CREATE statements and ignores the other ones, if any.
If the DDL or SQLDDL file does not define a column type, the driver then considers column values as
strings of 255 characters. A value that exceeds 255 is truncated. If the DDL or SQLDDL file provides
a type but not its length, the driver then uses standard lengths, such as 10 for integers. Precision and
scale are mandatory for the DECIMAL data type.
2012-03-1567
Data access driver reference