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.