The Preferences window allows you to set the connectivity type, default directory for saved files, and several other options. They include the QCD Access option, Execute SQL option, and the Data Demographics capture option.
For more information on connecting using ODBC or CLIv2 see the following:
1 Click Tools > Options> Preferences.
The Preferences dialog box opens.
2 Use the tabs to select the setting you want.
The following table explains each tab in the dialog box.
3 Click OK.
|
Options |
Description |
|
Connectivity tab |
|
|
ODBC |
Select this option to create a connection using ODBC. For more information, see “Connecting Through ODBC” on page 36. |
|
CLI |
Select this option to create a connection using CLIv2. For more information, see “Connecting Through CLIv2” on page 37. |
|
Path tab |
|
|
Default Directory |
Enter the directory where you want files stored when saved. Use the Browse (...) button to browse. |
|
General tab |
|
|
Use X views (DBC and QCD) |
Check this box to set Index Wizard to use information of Data Dictionary and QCD captured by the logged on user only. If a message appears to create restricted views, click Yes to create the missing views, or click No to continue without X views. Note: For additional information on X views, see “Creating Restricted DBC Views” on page 141. |
|
Use X views (QCD only) |
Check this box to set Index Wizard to use QCD information captured by the logged on user only. Note: For additional information on X views, see “Creating Restricted DBC Views” on page 141. |
|
Use SQL Assistant instead of Execute SQL Query window |
Check this box to have Teradata SQL Assistant execute SQL statements (default). |
|
Capture demographics to objects referred in workload |
Check this box to have Index Wizard capture additional information for Data Demographics. This option is used when a workload is created by using statement text or by using the DBQL. |
|
Select sample size for statistics collection |
Select the sample size (percentage) to be used for statistics collection during query capture when defining a workload from DBQL statements or using SQL statement text. The default is 100. |
|
Default perm space for QCD creation (MB) |
Enter the default space in megabytes that you want to use for a QCD when creating a workload. |