Submitting Part of a Query - SQL Assistant

Teradata SQL Assistant for Microsoft Windows User Guide

Product
SQL Assistant
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2430
lifecycle
previous
Product Category
Teradata Tools and Utilities

Submitting Part of a Query

1 Select Tools > Options.

2 Select the Query tab.

3 Select the option Submit only the selected Query text, when highlighted.

4 From the Query Window, select part of the query by highlighting it.

5 Do one of the following:

  • On the toolbar, click .
  • Press F5.
  • Note: While the query is executing, only the part of the query that you executed has a red background and is read only.

  • Insert an EXIT statement within the query by inserting the word EXIT following the semicolon that ends the last statement to process.
  • Note: The word EXIT must be the next non-whitespace/non-comment text after the semicolon that ends the last part of the query being submitted. It must also be on a new line, and can be preceded by whitespace.