Command Execution in Macros | Basic Teradata Query - Command Execution in Macros - Basic Teradata Query

Basic Teradata® Query Reference

Product
Basic Teradata Query
Release Number
17.00
Published
December 2020
Language
English (United States)
Last Update
2020-12-12
dita:mapPath
zqt1544831938740.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2414
lifecycle
previous
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.

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