Unlocking the Power of Teradata Macros: Features, Creation, and Execution

What is a Teradata Macro?

The Teradata macro executes multiple SQL queries in a single transaction, ensuring that all requests are successful or changes to database objects are rolled back.

What are the Features of Teradata Macros?

• Macros encapsulate application logic and control access to it
• The code of macros is stored in DBC tables
• Because macros are stored in DBC tables, they are available for all client tools.
• Macros can be called with parameters and are, therefore, flexible.
• Macros can be used, for example, to ensure referential integrity.
• Macros are optimized before execution.
• Macros can execute other macros.

How is a Macro created?

CREATE MACRO ShowSubscribers AS
(
  SELECT Lastname, Firstname FROM Subscriber;
);

How is a Macro changed?

REPLACE MACRO ShowSubscribers AS
(
  SELECT Lastname, Firstname, BirthDate FROM Subscriber;
);

How is a Macro dropped?

DROP MACRO ShowSubscribers;

How is a Macro executed?

EXECUTE ShowSubscribers;

More details can be found in the official Teradata documentation.