Open topic with navigation
Step 1 of the Text Wizard enables you to define global DSN (Data Source Name) settings for the data source. The options in Step 1 are a subset of the conventional ODBC configuration settings. However, configuration is simpler because only relevant entries are required in this dialog box.
|Define Data Source|
|Data Source Name||String that identifies this Text data source configuration in the system information. Examples include "Accounting" or "Text Files."|
System DSN — These data sources are local to a computer, rather than dedicated to a user. The system, or any user having privileges, can use a data source configured with a system DSN.
User DSN — These data sources are local to a computer, and may only be used by the current user.
|Description||Optional long description of a data source name. For example, "My Accounting Files" or "My Text Files in the Accounting Directory."|
|Database Location||Directory in which the text files are stored. If none is specified, the current working directory is used.|
|Define File Defaults|
Specifies the file extension to use for data files. The setting cannot be greater than three characters.
The default is .txt, which is used for all Create Table statements. The default is also used when no extension is specified.
Sending a Create Table statement using an extension other than .txt causes an error. For other SQL statements such as Select or Insert, you can specify an Extra Extension.
In SQL statements such as Select or Insert, you can specify an extension other than the Extension setting. Files with the extensions specified in the two extension fields are displayed in Step 2 of the Text File Wizard.
|Extra Extensions||An extension other than the Extension setting that can be specified in SQL statements, such as Select or Insert. Files with an extension specified in either of the two extension fields is displayed in Step 2 of the Text File Wizard.|
The type of text file: comma, tab, fixed, or stream.
This default and the Delimiter Character default are used when an application encounters a file that has not been defined. The text file wizard itself, in Step 3, automatically determines the file type and delimiter of a particular file chosen in screen 2. These defaults are necessary to complete a Data Source definition so we provide the ability to change them on this screen.
|Delimiter Character||The character used as a delimiter in character-separated files. It can be any printable character, however the default is a comma (,).|
|Decimal Symbol||The decimal separator is a comma or a period that is used when data is stored. The international decimal symbol (.) must be used in DML statements and parameter buffers.|
|Column Names in First Line||
Select this check box to indicate that column names are specified in the first line of the file.
Note: The Default Type, Delimiter Character, and Column Names in First Line settings apply only to tables not previously defined. These fields also determine the attributes of new tables created with the Create Table statement.
|Allow Update And Delete||
Indicates whether the data source allows Update and Delete statements. The check box is cleared by default, because Update and Delete statements cause immediate changes to a table but only one connection at a time can operate on the table.
When this option is checked, the table can be opened only by the current connection. Each update and delete on a text file can cause significant changes to the file, and performance may be poor. Consider a more appropriate database format if performance is a significant factor.
|Rows To Scan||
The number of rows in a text file that the driver scans to determine the data types in the file. The default is 25. It also determines the field lengths during the scan.
Note: The Rows to Scan setting applies only to tables not previously defined. This field also determines the attributes of new tables created with the Create Table statement.
After defining these settings, click Next to proceed to Text Wizard Step 2. Or click Back to return to the Select Data Source dialog box.
Note: You must complete the top of this dialog box to enable the Next button.