General Rules - Basic Teradata Query

Basic Teradata Query Reference

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

Specify BTEQ commands in any combination of uppercase, lowercase, and mixed-case formats. Specify BTEQ commands on a single line, or on multiple lines using the continuation character.

Do not use a BTEQ command and a Teradata SQL request on the same line.

Signed numbers are not recognized for BTEQ command arguments. All numeric arguments must be positive values. Use of signed numbers might cause unpredictable parsing results. This restriction does not apply to SQL statements submitted through BTEQ.

Windows OS only: Enclose all file name variables within single or double quotation marks. In the following example, 'myscript.txt' is the file name:

.RUN FILE 'myscript.txt'

Additionally, when text follows a file name, the file name must be enclosed in quotation marks. For example:

.RUN FILE 'myscript.txt' SKIP 2

BTEQ Command Syntax Example

The following example of the BTEQ FORMAT command shows the correct use of the command elements. FORMAT specifies the conditional use of additional BTEQ output formatting commands.

   .SET FORMAT ON;

In this example, the FORMAT command is set to the ON option, enabling the processing of additional output formatting commands.