Result Set Viewer - Teradata Studio

Teradata Studio Express User Guide

Product
Teradata Studio
Release Number
16.00
Published
March 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
cxo1484765174902.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2042
lifecycle
previous
Product Category
Teradata Tools and Utilities

The Result Set Viewer provides an enhanced view of the result set, including options to hide columns, filter on column values, find column values, copy data to the clipboard, format cell data, and switch between grid and text view. The result set is displayed in its own view with its own toolbar.

You can change preferences to customize the view by, for example, displaying alternating row background colors, enabling or disabling row numbers, column headers, table grid lines, and thousand separator on numeric columns. You can change the max display row count, as well as the display null value and date format. Refer to Result Set Viewer Preferences for more detailed information of the Result Set Viewer preferences.

The Single Result Set Toolbar contains:
Icon Option Description
Preferences Click to open the Result Set Viewer Preferences page.
Show SQL Click to open a dialog that displays the SQL statement.
Set Focus Click to set the focus to the associated SQL editor.
Rename Result Tab Click to open a dialog that allows you to rename the result tab.
Text or Grid Display Click to switch the view of the result set data between grid or text. The default is grid.
Format Selected Cells Click to open the platform specific Font dialog which enables you to select the font, size, and color (on most platforms) of the selected cells.
Pin Result Set Click to pin the result set. Pinned result sets are not closed by the Clear All action. Pinned result sets must be closed manually.
Clear All Click to clear all result sets in the Viewer.
Save Click to save the result set data to a file within the workspace. The Eclipse Save Result dialog appears, which allows you to select the project, file name, file type, and export options.
Export Click to export the result set data to an external file. The Eclipse Export Result dialog appears, which allows you to select the file name, format, and export options.
Print Click to print the result set data. The Eclipse Print dialog appears, which allows you to select the printer, page range, and number of copies.
The Multiple Result Sets Toolbar contains:
Icon Option Description
Preferences Click to open the Result Set Viewer Preferences page.
Show SQL Click to open a dialog that displays the SQL statement.
Rename Result Tab Click to open a dialog that allows you to rename the result tab.
Rename Group Result Tab Select one of the group result tabs while in Tab display mode. Right- click the tab and select the Rename Group Result tab menu option.
Text or Grid Display Click to switch the view of the result set data between grid or text. The default is grid.
Sash or Tab Display Click to switch the display of the multiple result sets between a tab folder or side-by-side sash framework. The default is tab folder. You can remove a result set from the sash framework by clicking the .
When result sets are displayed in a sash framework, you can not select a single result set for export, save, or print options.
Pin Result Set Click to pin the result set. Pinned result sets are not closed by the Clear All action. Pinned result sets must be closed manually.
Refresh Result Set List Click to refresh all of the removed result sets.
Save Click to open to the Eclipse Save Result dialog which allows you to select the project, file name, file type, and export options and save the selected result set to a file within the workspace.
This option is unavailable when result sets are displayed in the sash framework.
Save All Click to open the Eclipse Save Result dialog which allows you to select the project, file name, file type, and export options and save all of the result sets to a file within the workspace. This option is enabled when you execute multiple SQL statements in a single execution, using the following SQL Editor menu options: Execute All, Execute Select Text (and more than one SQL statement is selected), or Execute Selected Text as One Statement.
Export Click to open the Eclipse Export Result dialog which allows you to select the file name, format, and export options and export the selected result set to an external file. This option is unavailable when result sets are displayed in the sash framework.
Export All Click to open the Eclipse Export Result dialog which enables you to select the file name, format, and export options and export all of the result sets to an external file. This option is enabled when you execute multiple SQL statements in a single execution, using the following SQL Editor menu options: Execute All, Execute Select Text (and more than one SQL statement is selected), or Execute Selected Text as One Statement.
Print Click to open the Eclipse Print dialog which enables you to select the printer, page range, and number of copies to print the selected result set. This button is disabled when result sets are displayed in the sash framework.
Print All Click to open the Eclipse Print dialog which enables you to select the printer, page range, and number of copies to print all of the result sets. This option is enabled when you execute multiple SQL statements in a single execution, using the following SQL Editor menu options: Execute All, Execute Select Text (and more than one SQL statement is selected), or Execute Selected Text as One Statement.
The Grid Menu contains:
Icon Option Description
Hide Column Click to hide the selected column
Show All Columns Click to show all columns. Previously hidden columns are also shown.
Select Column Click to select the entire column.
  Auto resize column Click to resize the column to fit the largest cell.
  Auto resize row Click to resize the row to fit the largest cell.
Rename column Click to rename the column header.
Find Click to search for a result set data value.
  Find Next Click to find the next match value in the result set data.
  Find Next Reverse Click to find the next match value in the result set data in the reverse direction.
Aggregates Click to compute aggregates for the selected column values.
Filter column Click to create a filter on the column data.
Remove filters Click to remove filters for the column.
Freeze column Click to freeze scrolling at the selected column. All columns to the left are displayed. All columns to the right are scrolled. To unfreeze, click again.
Format Selected Cells Click to open the platform specific Font dialog which enables you to select the font, size, and color (on most platforms) of the selected cells.
Copy Cells Click to copy the cell data to the clipboard. The default is to copy the cell data into an HTML table. You can copy cells to Excel, Word, or an email.
The Text Display Menu contains:
Icon Option Description
Copy Click to copy the selected text to the clipboard. The text is copied as a string to the clipboard.
  Select All Click to select the entire text string displayed.
Find Click to search for a result set data value within the text string.
  Find Next Click to find the next match value in the result set data.
Other Actions:
Option Description
Sort Column Click the column header. An arrow appears indicated the direction of the sort, ascending or descending order. Clicking a third time returns the column back to its original order.
Move Column Select a column and drag it just past the new position.
Long Text Display If a cell contains text that exceeds the length specified by the Long Text Boundary Size in the Result Set Viewer Preference, only the first 20 characters of the text is displayed. Double-click the data to display the full text.
LOB Display When a result set contains CLOBs (Character Large Objects) or BLOBs (Binary Large Objects), a dialog appears that enables you to indicate whether to save the LOB to a file and the file location, as well as whether to display images in the Result View.