Setting Answerset Options - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

SQL Assistant
Release Number
English (United States)
Last Update
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.

1 Select Tools > Options.

2 Click the Answerset tab.

Table 20 explains each option.


Table 20: Answerset Tab in the Options Dialog Box 



Display alternate Answerset rows in color

Select this item to display colors for alternate rows in the Answerset. Use the color picker to select 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.