Executing 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

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

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

EXECUTE macroname;

To execute the macro deptdisplay, enter:

EXECUTE deptdisplay;