Command Syntax Errors and Command Settings | Basic Teradata Query - Command Syntax Errors and Command Settings - Basic Teradata Query

Basic Teradata® Query Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Basic Teradata Query
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2025-04-02
dita:mapPath
gxl1691484661681.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
psp1479308573013
Product Category
Teradata Tools and Utilities

Many BTEQ commands serve the purpose of enabling the state of a persistent setting to be changed. For example, RETRY command use enables users to change the state of BTEQ's RETRY setting to either ON or OFF. The SHOW CONTROLS command enables users to see the current state of such settings.

In general, BTEQ is strict about command syntax violations. When it detects a violation, it will produce an error message and attempt to keep the prior state of settings preserved.