Execute Macro (any) (Teradata Database) - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
qhj1503087326201.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

Macros are treated as simplified stored procedures whose parameters are all Input parameters. They may be user-defined or system-supplied. When dragging an Execute Macro element onto a Run Unit, the following tree element is created

Variable Creation > Input > Variables: SQL Elements pane - Run Units > Execute Macro

At the same time, a Properties dialog is displayed so that a Macro can be selected and argument descriptions can be viewed.

Variable Creation > Input > Variables: SQL Elements pane - Run Units >Execute Macro Properties

This dialog is the same as for a Stored Procedure Call but there is no Expert Options tab. Note that the option to Generate Arguments generates Literal elements of the appropriate type. It does not generate Literal Parameter elements because Macro parameters do not return data.