SQL Handling - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
sbq1486739977986.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities

Common

The Results Handler options enable you to select a result set handler to process SQL result sets.

Option Description
Qualify names for drag and drop in SQL Editor (Default) Clear this check box if you do not want names qualified when you drag and drop objects from the Data Source Explorer to the SQL Editor.
Prompt for notes Check this check box if you want to be prompted to enter SQL execution notes. When you execute SQL statements, a dialog appears which prompts you to enter the note. The SQL History view displays your note text in the Note column.
Auto-connect to profile when selected in SQL Editor Select this check box to automatically connect to the selected profile within an instance of the SQL Editor. (Default)
Results Handler Select one:
  • Teradata Export Wizard (File Export) — option handles result sets by exporting SQL to a file using the Teradata Export Wizard .
  • (Default) Teradata Result Set Viewer — option displays SQL result sets in the Result Set Viewer.
Sampler Content Size Type a value for the sample content size. Default is 100.

Teradata

The following Large Value Handling settings enable you to set column size restrictions for creating BLOBs and CLOBs in Teradata tables.

Option Description
Handle Binary/Byte columns as BLOBs if size > Specify the limits for creating BLOBs for large binary values in results. Binary results are treated as BLOBs when their column size is greater than the value you enter. A value of zero specifies that all binary values are treated as BLOBs. Default is 30.
Handle Character columns as CLOBs if size > Specify the limits for creating CLOBs for large character values in SQL results. Character values in results are treated as CLOBs when their column size is greater than the value you enter. A value of zero specifies that all character values are treated as CLOBs. Default is 16384.

Aster

The following Large Value Handling settings enable you to set size restrictions for creating BLOBs and CLOBs in Aster tables

Option Description
Handle Binary/Byte columns as BLOBs if size > Specify the limits for creating BLOBs for binary results. Binary results are treated as BLOBs when their column size is greater than the value you enter. A value of zero specifies that all binary values are treated as BLOBs. Default is 30.
Handle Character columns as CLOBs if size > Specify the limits for creating CLOBs for results. Character values in results are treated as CLOBs when their column size is greater than the value you enter. A value of zero specifies that all character values are treated as CLOBs. Default is 2147483647.

Sounds

The Sounds settings enable you to customize audible indicators for success and failure notification sounds during SQL execution.

Option Description
Success Sound Select one of these options:
  • No sound (default)
  • System Beep
  • Secret Sound

If you select Secret Sound, click Browse to select a sound file on your system.

Failure Sound Select one of these options:
  • Success Sound
  • No sound (default)
  • System Beep
  • Secret Sound

If you select Secret Sound, click Browse to select a sound file on your system.