Command Execution in Macros | Basic Teradata Query - Command Execution in Macros - 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

BTEQ executes commands and SQL statements in the same order they were entered. Each BTEQ command must be enclosed in an SQL ECHO statement. When the macro is executed, the database executes the SQL statements and returns the contents of the ECHO statements (the BTEQ commands) to BTEQ.

To avoid unexpected results, Teradata recommends echoing BTEQ commands only in Field Mode. No error messages are issued, and the echoed text might be dumped rather than executed.