Use the Teradata Result Set Viewer preferences to configure views of result-set data.
- Click Window in the top menu and select Preferences.
- Expand Teradata Datatools Preferences.
- Select Result Set Viewer Preferences.
[Optional] Under Alternating Row Colors Option, enable the display of an alternate row background color:
- Select the Display alternate Result Set rows in color check box.
- Right-click the color box, and select a color in the Color dialog.
- Click OK.
Under Grid Display Options, select the following options as appropriate:
Option Description 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 options 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 to effect any change you make. (*) Max Display Row Count Specify the maximum number of rows to display. The default value is 2000.You must be rerun the query to effect any change you make. 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.
Under Format Options, select the following options as appropriate:
Option Description Long Text Boundary Size Type the number of characters allowed for the long text boundary size. Default is 150 characters. If a data value length is longer than the long text boundary size, only the first 20 characters display. You can view the entire data value by double-clicking the value in the display grid. The value displays in a new window. Display 1000 Separator in Numeric Columns Select to display a 1000 separator in numeric columns. This option is disabled by default. Display Negative Numbers in Red Select to enable display of negative numbers in red. The options is enabled 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. See Java Simple Date Format.
Under Copy Column Delimiter, in the Delimiter Format field, select how you want columns delimited when the Copy data option is used on the grid display.
Option Description Comma Separated Uses commas as delimiters to separate column data (default). Tab Separated Uses tabs as delimiters to separate column data. User Defined Type the delimiter you want to use in the Delimiter Value field.
[Optional] Under Delimiter Value, select the following options as appropriate: you want column headers delimited when the Copy data option is used on the grid display.
Option Description Copy Include Column Headers Specifies to include column headers as delimited values when the Copy data option is used on the grid display. Copy Include Grid Lines Specifies to include grid lines as delimited values when the Copy data option is used on the grid display.
- [Optional] Under Viewer Window Options, select Reuse Result Set Viewer Window if you want newly generated result sets to display in the currently open Viewer window. If the check box is not selected, each new result set displays in a separate window in the Result Set Viewer.
- [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 Preferences dialog.