CREATE MACRO in Teradata

Macros are used to run a repeatable set of tasks.
A macro can be executed by Queryman, BTEQ or by another macro.

Syntax:
CREATE MACRO macro_name [parameters] AS
(
<SQL statements>
);


Example:
CREATE MACRO mc_employee AS
(
SELECT * FROM tbl_employee;
);