EXECUTE Syntax | SQL Statements | Teradata Vantage - EXECUTE Syntax (Macro Form) - Analytics Database - Teradata Vantage

SQL Data Manipulation Language

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-05
dita:mapPath
pon1628111750298.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esx1472246586715
lifecycle
latest
Product Category
Teradata Vantage™
{ EXECUTE | EXEC } macro_name [ ( macro_arguments ) ] [;]

Syntax Elements

macro_name
Name of the macro that is to be executed.
macro_arguments
{ parameter_name = constant_expression [,...] |
  constant_expression [,...]
}
parameter_name = constant_expression
Parameter name as defined in the CREATE MACRO request, and supplies the value for that parameter.
This is referred to as a named parameter list.
The value can be a constant, or an expression involving constants.
If a parameter is omitted, any default value defined for that parameter is inserted automatically.
constant_expression
Constant or an expression involving constants that specifies a parameter value.
Values are listed in left-to-right order according to the order in which parameter names were specified in the CREATE MACRO request definition. You can specify nulls by typing successive COMMA characters, for example, (a, , b).
This is referred to as a positional parameter list.
If a value is not supplied for a parameter, a comma must be entered to account for the missing parameter.
Any default value defined for that parameter is inserted automatically.