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.
- Select .
- Click the Common tab to set SQL rules for both Vantage and Aster Database.
- 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.
- 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.
- 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
- 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.
- Click the Teradata tab to set large value handling rules in Vantage.
- 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.
- 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.
- 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).
- Click the Aster tab to set large value handling rules in Aster databases.
- 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.
- 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.
- 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).
- Select the Sounds tab to customize audible indicators for success and failure notification sounds during SQL execution.
- Select a Success Sound option.
- Select a Failure Sound option
- [Optional] To clear selections and restore default settings, click Restore Defaults.
- Click Apply then OK to apply your changes and close the Preferences dialog.