This topic provides Text File Driver-specific information. For general information about this function, see the appropriate topic under ODBC API Reference.
The SQLConfigDataSource function that is used to add, modify, or delete a data source dynamically uses the following keywords.
|CHARACTERSET||For the Text driver, OEM or ANSI.|
|COLNAMEHEADER||For the Text driver, indicates whether the first record of data will specify the column names. Either TRUE or FALSE.|
|DEFAULTDIR||The path specification to the directory.|
|DESCRIPTION||A description of the data in the data source.
This sets the same option as Description in the setup dialog box.
|DRIVER||The path specification to the driver DLL.|
|DRIVERID||An integer ID for the driver. 27 (Text)|
|EXTENSIONS||Lists the file name extensions of the Text files on the data source.
This sets the same option as Extensions List in the setup dialog box.
|FIL||File type Text|
|FILETYPE||File type for the Text driver (Text).|
|FORMAT||For the Text driver, can be FIXEDLENGTH, TABDELIMITED, CSVDELIMITED (by a comma), or DELIMITED() (by the special character specified in the parentheses). The special character is one character in length and can be in character, decimal, or hexadecimal format.|
|MAXSCANROWS||The number of rows to be scanned when setting a column's data type based upon existing data.
For the Text driver, you can enter a number from 1 to 32767 for the number of rows to scan; however, the value will always default to 25. (A number outside the limit will return an error.)
This sets the same option as Rows to Scan in the setup dialog box.
|READONLY||TRUE to make file read-only; FALSE to make file not read-only.
This sets the same option as Read Only in the setup dialog box.