15.00 - 15.10 - SQL Used to Create a Macro - Teradata Database

Teradata Database Introduction to Teradata

Teradata Database
Release Number
Content Type
User Guide
Publication ID
English (United States)
Last Update

You use the CREATE MACRO statement to create Teradata Database macros.

For example, suppose you want to define a macro for adding new employees to the Employee table and incrementing the EmpCount field in the Department table. The CREATE MACRO statement looks like this:

    CREATE MACRO NewEmp (name VARCHAR(12),
                         number INTEGER NOT NULL,
                         dept INTEGER DEFAULT 100
    AS (INSERT INTO Employee (Name,
        VALUES (name,
        UPDATE Department
        SET EmpCount=EmpCount+1
        WHERE DeptNo=dept

This macro defines parameters that users must fill in each time they execute the macro. A leading colon (:) indicates a reference to a parameter within the macro.