Examples of Executing a Macro | Basic Teradata Query - 17.00 - Executing Macros - Basic Teradata Query

Basic Teradata® Query Reference

prodname
Basic Teradata Query
vrm_release
17.00
created_date
June 2020
category
Programming Reference
featnum
B035-2414-220K

Macros can be executed either interactively, or included in BTEQ scripts or input stream files.

To execute a macro interactively, use the SQL EXECUTE statement:

EXECUTE macroname;

To execute the macro deptdisplay, enter:

EXECUTE deptdisplay;