When to Negate a Request | Basic Teradata Query - Negating a Request - Basic Teradata Query

Basic Teradata® Query Reference

Product
Basic Teradata Query
Release Number
17.00
Published
December 2020
Language
English (United States)
Last Update
2020-12-12
dita:mapPath
zqt1544831938740.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2414
lifecycle
previous
Product Category
Teradata Tools and Utilities

At times, while creating a request, it is necessary to negate a statement to avoid creating unintended results.

If a request is being created using BTEQ interactively, and the line of the request being entered contains an error, use the Backspace key to remove text until the error can be corrected. Finish re-entering valid text to complete the line, and press Enter to start the next line of the request.

However, if while entering a line, Enter is pressed before correcting the text in error, the Backspace key cannot be used to correct the error. In this case, use the following steps to correct this issue:

  1. Continue the request with an additional statement that has invalid syntax.
  2. Press Enter.

This causes all statements in the request to be invalidated.