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:
|
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:
If you select Secret Sound, click Browse to select a sound file on your system. |
Failure Sound | Select one of these options:
If you select Secret Sound, click Browse to select a sound file on your system. |