16.00 - Creating a Macro - Teradata Studio

Teradata Studio User Guide

prodname
Teradata Studio
vrm_release
16.00
created_date
March 2017
category
User Guide
featnum
B035-2041-126K
Macros are SQL statements that the server stores and executes. Macros provide an easy way to execute frequently used SQL operations.
  1. In the Navigator, expand the Databases, right-click a database or user, and click Show Macros. A list of the macros defined in the connected system appears in the Object List Viewer. The list is filtered according to any filters you have applied.
  2. In the Object List Viewer toolbar, click .

    A Create Macro property form opens in the Details view.

  3. In the form, enter values for the new macro.
  4. [Optional] Click the SQL category to see the SQL code that will be executed on the connected system to create the new macro.
  5. Click Commit.
  6. Click OK. The property form shows the properties of the new macro.