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.