16.00 - Setting SQL Handling Preferences - Teradata Studio

Teradata Studio User Guide

prodname
Teradata Studio
vrm_release
16.00
created_date
March 2017
category
User Guide
featnum
B035-2041-126K

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. Click Window in the top menu and select Preferences.
  2. In the Preferences navigation pane, expand Teradata Datatools Preferences.
  3. Select SQL Handling. The SQL Handling dialog displays in the right pane. There are three tabs: Common, Teradata, and Aster.
  4. Click the Common tab to set SQL rules for both Teradata Database 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 be able 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. Under Results Handler, the Teradata Result Set Viewer is selected as the results handler for processing SQL result sets.
  5. Click the Teradata tab to set large value handling rules in Teradata 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 zero specifies that all character values are handled as CLOBs.
  6. 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.
  7. [Optional] To clear selections and restore default settings, click Restore Defaults.
  8. To apply your changes, click Apply.
  9. Click OK to apply your changes and close the Preferences dialog.