Setting SQL Handling Preferences - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-10
dita:mapPath
pfg1542649412202.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
Use the SQL Handling Preferences dialog to set very large value handling rules for objects, such as BLOBs, CLOBs, and LOBs, in the SQL Editor.
  1. Select Window > Preferences > Teradata Datatools > SQL Handling.
  2. Click the Common tab to set SQL rules for both Vantage and Aster Database.
    1. Select Qualify names for drag and drop in SQL Editor to qualify names when objects are dragged from the Data Source Explorer and dropped in the SQL Editor. Clear this check box if you do not want names qualified.
    2. Select Prompt for notes to enter a note when you execute SQL. The Note dialog lets you enter a text value that displays in the Teradata SQL History view in the Note column.
    3. Select one of the following under Results Handler:
      Option Description
      Teradata Export Wizard (File Export)

      Export SQL to a file using the Teradata Export Wizard.

      Make sure the Write all Exported result sets to a single file setting is selected. For more information, see Setting Export Preferences.

      Teradata Result Set Viewer Display SQL result sets in the Result Set Viewer
  3. Click the Teradata tab to set large value handling rules in Vantage.
    1. In Handle Binary/Byte columns as BLOBs if size >, type the number of bytes for column size which when exceeded, the object is handled as a binary large object (BLOB).
      A value of zero specifies that all binary values are treated as BLOBs.
    2. In Handle Character columns as CLOBs if size >, type the number of characters which when exceeded, the object is handled as a character large object (CLOB). The default is 2147483647.
      A value of zero specifies that all character values are handled as CLOBs.
  4. Click the Aster tab to set large value handling rules in Aster databases.
    1. In Handle Binary/Byte columns as BLOBs if size >, type the number of bytes for column size which when exceeded, the object is handled as a binary large object (BLOB).
      A value of zero specifies that all binary values are handled as BLOBs.
    2. In Handle Character columns as CLOBs if size >, type the number of characters which when exceeded, the object is handled as a character large object (CLOB). The default is 2147483647.
      A value of 0 (zero) specifies that all character values are handled as CLOBs.
  5. Select the Sounds tab to customize audible indicators for success and failure notification sounds during SQL execution.
    1. Select a Success Sound option.
    2. Select a Failure Sound option
  6. [Optional] To clear selections and restore default settings, click Restore Defaults.
  7. To apply your changes, click Apply.
  8. Click OK to apply your changes and close the Preferences dialog.