Use the Teradata Result Set Viewer preferences to configure the display of result set data.
- Click Window in the main menu and select Preferences.
- Expand Teradata Datatools Preferences.
- Click Result Set Viewer Preferences.
In the Result Display tab, select the following options as appropriate:
Option Description Display alternate Result Set rows in color Select the check box to display color in alternate rows of the result set. Click the color box to open the Color dialog and select a basic color or define a custom color to use. This option is disabled by default. Show Row Numbers Select to show row numbers in the grid display. This option is enabled by default. Show Column Headers Select to show column headers in the grid display. This option is enabled by default. Show Table Grid Lines Select to display lines between rows and columns in table grid display. This option is enabled by default. (*) Display Column Titles rather than Column Names Select to display column titles (if available) instead of column names as labels in column headers. This option is disabled by default.You must rerun the query for these changes to take effect. (*) Max Display Row Count Specify the maximum number of rows to display. The default value is 2000.You must rerun the query for these changes to take effect. Long Text Boundary Size Enter the number of characters that will be displayed. The default for this option is 150. Display Negative Numbers in Red Select to enable display of negative numbers in red. This option is enabled by default. Translate some Control Characters Translate control characters in the range of 0x0086 through 0x009f as if the bytes 0x86 through 0x9f were translated by the Windows code page cp1252. The query must be rerun for the change in this option to take effect. Reuse Result Set Viewer Window Select to refresh the current window with new result sets generated by the SQL Editor. If deselected, the Result Set Viewer creates a new window for each result set generated.
In the Data Format tab, select the following options as appropriate:
Option Description Display Null value as Specify the value or string you want displayed when a value results in an empty set or zero value. The default value is null. Display 1000 Separator in Numeric Columns Select to display a 1000 separator in numeric columns. This option is disabled by default. Number Fractional Digits Displayed Enter the number of decimal places to display for Float values. By default, the value is blank. The number must be between 1 and 10. Display Dashes between Bytes for Binary Data Values Select to display a dash between each byte of the value for greater ease of reading, for example: 63-b1-a3-62. This option is enabled by default. Display Float Values using Scientific Notation Select to display Float values using scientific notation rather than in decimal format. This option is disabled by default. Display Time/Timestamp without Time Zone Select to display the time/timestamp without indicating the time zone. For example, instead of 11:37:58.123+02.00 the Results Set Viewer would show 11:37:58.123. This option is disabled by default. Display Date Format Specify the format to use to display the date in the result set. Default format is yyyy-mm-dd. When you specify the format, you must use the Java SimpleDateFormat notation to format the date. Date Format Value If you selected User Defined for the Display Date Format option, enter the format.
In the Copy Options tab, select the following options as appropriate:
Option Description Delimiter Format Select how you want columns delimited when the Copy data option is used on the grid display:
- Comma Separated: Uses commas as delimiters to separate column data (default).
- Tab Separated : Uses tabs as delimiters to separate column data.
- User Defined: Enter the delimiter you want to use in the Delimiter Value field.
Copy Include Column Headers Select to include column headers as delimited values when the Copy data option is used on the grid display. Copy Include Grid Lines Select to include grid lines as delimited values when the Copy data option is used on the grid display.
- [Optional] To clear selections and restore default settings, click Restore Defaults.
To apply your changes, click Apply.
Clicking Apply or OK refreshes the current display of result sets in the Result Set Viewer to correspond with your changes.
- Click OK to apply your changes and close the Result Set Viewer Preferences dialog.