SQL Used to Modify a Macro - Teradata Database

The following example shows how to modify a macro. Suppose you want to change the NewEmp macro so that the default department number is 300 instead of 100. The REPLACE MACRO statement looks like this:

    REPLACE MACRO NewEmp (name VARCHAR(12),

                          number INTEGER NOT NULL,

                          dept INTEGER DEFAULT 300)

    AS (INSERT INTO Employee (Name,

                              EmpNo,

                              DeptNo)

        VALUES (name,

                number,

                dept)

        ;

        UPDATE Department

        SET EmpCount=EmpCount+1

        WHERE DeptNo=dept

        ;

       )

    ;