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 access control 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.

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

You might also like