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
(

);

Example:

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