Rows to Scan
- Last Updated: October 3, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Cloudera Impala 7.1
- dBase 7.1
- Flat files/Text 7.1
- MySQL 7.1
- Pervasive (Btrieve) 7.1
- XML 7.1
- Documentation
Attribute
ScanRows (SR)
Purpose
The number of rows in a text file that the driver scans to determine the data types in the file.
Valid Values
0 | x
where:
- x
- is a positive integer.
Behavior
If set to 0, all rows in the file are scanned.
If set to x, x rows are scanned to determine the data types in a file.
Notes
- The Rows to Scan setting applies only to tables not previously defined. It also determines the attributes of new tables created with the Create Table statement.
Default
25