EXECUTE Syntax | SQL Statements | Teradata Vantage - 17.05 - EXECUTE Syntax (Macro Form) - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Release Date
January 2021
Content Type
Programming Reference
Publication ID
B035-1146-175K
Language
English (United States)
{ 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.