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

Teradata Database Introduction to Teradata

Product
Teradata Database
Release Number
15.00
15.10
Content Type
User Guide
Publication ID
B035-1091-151K
Language
English (United States)
Last Update
2018-09-25

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,
                              EmpNo,
                              DeptNo
                             )
        VALUES (name,
               number,
                dept
               )
        ;
        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.