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;