SQLConfigDataSource (Text File Driver)
Note
|
|---|
|
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.
|
Keyword |
Description |
|---|---|
|
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. |
