Modify preferences by selecting
.In the Preferences window, you can filter the information or navigate to the preference. Changes to preferences are stored within your workspace.
Data Management Preferences
Preference | Description | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Connectivity | Configures the connectivity Driver Definitions by adding, editing, removing, or copying driver definitions. | ||||||||||
Label Decorations | Specifies the display format for columns in the Data Source Explorer. | ||||||||||
SQL Development |
|
General Preferences
Preference | Description |
---|---|
Appearance | Customizes the display appearance by offering options for theme, color, font, and label preferences. |
Compare/Patch | Customizes the display when comparing text files. |
Content Types | Enables you to associate editors with file types. |
Editors | Customizes editor behaviors and functions and adds or removes the editors and file types available in the Content Types preferences. |
Globalization | Customizes global settings for Unicode and text/graphic support. |
Keys | Customizes the keyboard bindings. |
Workspace | Changes the text file encoding for the workspace. |
Teradata Datatools Preferences
Preference | Description |
---|---|
Teradata Datatools | Sets query and size preferences for all Teradata datatools. |
Connection Options | Sets connection preferences for connection profiles. Preferences include maximum connections per profile. For Teradata connections, queryband options allow you to specify user and metadata queryband settings, as well as FastLoad/export options. In addition, you can specify default JDBC Connection Properties for Teradata and Aster connections. |
Data Source Explorer Load | Sets preferences in the Data Source Explorer for display of database and user object hierarchy and for load settings that determine which databases and user objects to load. |
Data Utilities | Specifies the root directory location and thresholds for disk cache and maximum rows allowed for COMMIT transactions. You can also set the preference to be prompted with a confirmation dialog to continue/stop load in case of column(s) mismatch. |
Dependencies | Sets preferences for accessing the Meta Data Services web service |
Export | Sets the preference to launch a native editor and customizes export options. Select Write SQL and Result Status to the Export File to include the SQL and result status when exporting. |
History | Sets the exclude options for the History database, maximum number of rows to display, and which columns to show in the SQL History View. |
Logging | Specifies your preferences for logging messages. |
New Profile Connection Types | Sets which types of connection profiles to show as options in the New Connection Profile dialog. |
Result Set Viewer | Sets preferences for Teradata Result Set Viewer. |
SQL Formatter | Sets preference options for the SQL Formatter. |
SQL Handling | Sets handling preferences for SQL result sets and options for drag-and-drop and auto-connect functions. You can also specify the LOB sizes for handling large values for Teradata and Aster, and customize success and failure notification as sounds during SQL execution. |
Table Data Editor | Sets preferences for selection color options, filter thresholds, and editor display and copy/paste options. |