Setting Answerset Options - Teradata SQL Assistant

Teradata® SQL Assistant for Windows User Guide

Teradata SQL Assistant
Release Number
October 2018
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

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.

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.

  1. Select Tools Options.
  2. Click the Answerset tab and complete the fields.
    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 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 rearrange 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.
    • Click .
    • Right-click in the Answerset window and select Grid Lines.
    Display 1000 separators in numeric columns

    This means 1000 separators (commas) appear in numeric columns.

    The default is selected.

    Display negative numbers in Red

    This option displays negative values in red in the Answer pane.

    The default is cleared.

    Display Column Titles rather than Column Names

    This option allows the Answerset columns to display titles rather than names. The default 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

    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.

    The default is selected.

    Display Float values using scientific notation

    If selected, Float column data displays in scientific notation. For example, 1.234567e04.

    The default is cleared.

    Use default file names for LOB columns

    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.

    The default is cleared.

    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

    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.

    The default is 2000.