Introducing Radical.sh

Forget Code launches a powerful code generator for building API's

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:
  1. CREATE MACRO macro_name [parameters] AS
  2. (
  3. <SQL statements>
  4. );


Example:
  1. CREATE MACRO mc_employee AS
  2. (
  3. SELECT * FROM tbl_employee;
  4. );