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 Options 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. |
Object List Viewer |
Specifies which toolbars and menu actions are visible on the Object List Viewer. |
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. |
Studio Perspectives |
Sets options for opening perspectives. |
Table Data Editor |
Sets preferences for selection color options, filter thresholds, and editor display and copy/paste options. |