O'Reilly logo

Teradata SQL by Tom Coffing, Mike Larkins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 18 - Macro Functions

“Don't count the days. Make the days count.”

-Muhammad Ali

 

The 14 rules of Macros

  1. Macros can contain one or more SQL Statements
  2. Macros are a database Extension in Teradata and not ANSI-Standard
  3. Macros do NOT require PERM Space
  4. Macros are stored in the Data Dictionary in the USER DBC
  5. Every statement in the macro must end in a semi-colon ;
  6. Only one DDL Statement can exist in a Macro and it must be the last statement
  7. Input Parameters can be passed to the Macro
  8. Macros run when users use the EXEC Macro Command
  9. Macros can be executed from any viable front end, especially the Nexus
  10. Macros can call views and even other Macros
  11. All SQL Statements inside a Macro are considered one Transaction
  12. Each Macro name must be a ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required