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.