Setting Answerset Options

Setting Answerset Options - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

Product

SQL Assistant

Release Number

15.00

Language

English (United States)

Last Update

2018-09-27

dita:id

B035-2430

lifecycle

Product Category

Teradata Tools and Utilities

Setting Answerset Options

Use the following procedure to control the Answerset and the appearance of data in the Answerset by setting options on the Answerset tab of the Options dialog box.

Additional data options that apply to both the Answerset window and to Exported data can be set on the Data Format tab. See “Setting Data Format Options” on page 121.

To set Answerset options

1 Select Tools > Options.

2 Click the Answerset tab. Table 20 explains each option.

Table 20: Answerset Tab in the Options Dialog Box
Option	Description
Display alternate Answerset rows in color	Select this item to display colors for alternate rows in the Answerset. Use the color picker to choose a color. The color choices include a Custom tab, a Web tab and a System tab. The default is cleared.
Open new Answersets in Move Columns Mode	Selecting this option activates “Move Columns mode” when a new Answerset opens, which allows you to re-arrange the columns by dragging columns to the desired position. The default for Move Columns mode is off.
Display grid lines in future Answerset columns	The default value of this option is selected. Gridlines appear when a new Answerset window is created. Right-click in the Answerset window and select Grid Lines. On the Answerset toolbar click .
Display 1000 separators in numeric columns	The default value of this option is selected. This means 1000 separators (commas) appear in numeric columns.
Display negative numbers in Red	This option displays negative values in red in the Answer pane. The default value of this option is cleared.
Display Column Titles rather than Column Names	This option allows the Answerset columns to display titles rather than names. The default value of this option is selected. This means the column title is used as the column header when returning data to the Answerset window. If cleared, column names appear. Column titles can be defined at the time a table is created, or as part of a `SELECT` statement. Generally, a column title is more descriptive than the column name itself.
Wrap wide headers across 2 lines if the data is narrow	The default value of this item is selected. This option allows column titles that are wider than the maximum data width in that column to be wrapped across two lines to display narrower columns. If this option is not selected, column titles display on a single line.
Display Float values using scientific notation	The default value of this option is cleared. If selected, Float column data displays in scientific notation. For example, 1.234567e04.
Use default file names for LOB columns	The default value of this option is cleared. If selected, the file names used for LOB columns are constructed from the column title and a default file type. You are not prompted to enter this information.
Default file type for BLOB columns	This file type is used for BLOB columns when the above option is selected.
Maximum number of answer rows to display	The default value of this option is 2000. This number is the maximum number of answer rows that are retrieved from the database before you are prompted whether you want to continue retrieving further rows. If you want all remaining rows to be retrieved without further prompts, answer No to the following question: Cancel at <number> rows in accordance with settings? When prompted to continue, all remaining rows are retrieved without any further prompts.