Setting SQL Handling Preferences - Teradata Studio

Teradata Studio Express User Guide

Product
Teradata Studio
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
mco1486739961504.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2042
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. 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.