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.10
Published
February 2022
Language
English (United States)
Last Update
2022-02-03
dita:mapPath
nnw1608578382132.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.