Command Execution in Macros - Basic Teradata Query - 16.20

Basic Teradata Query Reference

prodname
Basic Teradata Query
vrm_release
16.20
category
Programming Reference
featnum
B035-2414-108K

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

It is recommended to echo 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.