16.20 - Setting Query Options - Teradata SQL Assistant

Teradata® SQL Assistant for Windows User Guide

Product
Teradata SQL Assistant
Release Number
16.20
Published
October 2018
Language
English (United States)
Last Update
2020-01-03
dita:mapPath
gfk1537201040714.ditamap
dita:ditavalPath
ft:empty
The SQL Assistant option Allow use of ODBC SQL Extensions in queries no longer exists. Clear the ODBC Data Source option Disable Parsing to allow the use of ODBC SQL extensions.
  1. Select Tools > Options.
  2. Click the Query tab.
  3. Complete the fields.
    Option Description
    Close the Answerset window before submitting a new query

    When selected, all Answerset windows that are not marked as Do not Close are closed before running a new query.

    The default value is selected.

    Disable parsing for Queries larger than

    If a query is larger than this size when loaded from a file, or from History, then all parsing will be switched off. The query will display plain text without any highlighting, uppercasing, outlining, or code completion functionality.

    The default is 900 KB.

    Disconnect from database when a query ends

    When selected, this option starts and stops the connection to the data source with each query.

    The default value is cleared.

    When using this mode, all transactions must be committed or rolled back within the query that started them.
    Limit parsing for Queries larger than

    If a query is larger than this size when loaded from a file, or from History, a simpler language definition will be used in order to improve performance. In this case only the more common keywords and functions will be highlighted, and automatic uppercasing will not occur.

    The default is 200 KB.

    Minimize SQL Assistant while a query is running

    When selected, Teradata SQL Assistant minimizes when a query runs.

    The default is cleared.

    Prompt for a note before running a query

    When selected, Teradata SQL Assistant displays a dialog box to enter notes whenever a query is submitted. Also, on the toolbar click (you can toggle this option on or off).

    To add a note after the query has completed, double-click the note cell, or click the cell and press Enter. The Query Note dialog appears.

    The default is cleared.

    Provide audible notification when a query ends

    When selected, Teradata SQL Assistant makes a sound when a query is complete. The sound also occurs if the query times out, the number of rows exceeds the output limit, or the query is canceled.

    This option is also available by clicking .

    The default is cleared.

    Stop query execution if an SQL error occurs

    When selected, queries are stopped if an error occurs, even if the query contains additional statements that have not yet been executed.

    If a query with conditional logic based on the ERRORCODE command is used, clear this option. If this option remains selected, Teradata SQL Assistant stops processing the query before it attempts to evaluate the conditional logic.

    Queries with conditional logic based on ERRORCODE and ending with an EXIT command are reported as successful if the return code is zero.

    The default is selected.

    Submit only the selected query text when highlighted

    When selected, even if part of the query is highlighted, the entire query is executed when submitted.

    The default is cleared.

    Allow use of Named Parameters in queries

    This setting allows the use of Named Parameter substitution in queries.

    The default is selected.

    Prompt to save the Query Log when a Query ends

    When selected, Teradata SQL Assistant displays a dialog that allows the Query Log to be saved after a multi-statement query is executed.

    The default is cleared.

    Prompt to save queries that have been changed, but not run, before closing

    When selected, Teradata SQL Assistant displays a dialog to save the query to either a file or to the History database before closing the Query window or closing Teradata SQL Assistant.

    A prompt to save the query only displays if changes were made to the query since opening a file, saving to a file, executing the query, copying a query from the History window by clicking on the SQL, or clicking Clear Query.

    The default is selected.