BTEQ Command Elements | Basic Teradata Query - 17.00 - BTEQ Command Elements - Basic Teradata Query

Basic Teradata® Query Reference

prodname
Basic Teradata Query
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2414-220K

BTEQ commands consist of several elements, some of which are required and some of which are optional. The following table describes the elements of BTEQ command syntax, using the FORMAT command example discussed in General Rules.

.SET FORMAT ON;
BTEQ Command Elements 
Command Element Syntax Example Required or Optional Purpose
BTEQ command identifier . (dot character) Optional, but recommended Identifies the beginning of a BTEQ command and distinguishes it from SQL
Keyword SET Optional for many commands Identifies that the command sets a processing condition
Command keyword FORMAT Required Specifies the function
Options ON Required for some commands; otherwise, optional Specifies processing condition
Variable text Required for some commands; otherwise, optional Specifies a value or entity for processing
BTEQ command terminator ; (semicolon character) Required for some commands; otherwise, optional Identifies the end of the BTEQ command