- database_name
- The name of the containing database for macro_name if something other than the current database.
- macro_name
- The name of the new macro. If a fully qualified name is not specified, the default database or user is used.
- using_modifier
- One or more variable parameter names. A value is substituted for each parameter name when the request is processed. Also see the information about the USING request modifier in Teradata Vantage™ - SQL Data Manipulation Language, B035-1146. This is an optional phrase.
- locking modifier
- A lock on a database, table, view or row hash.
- SQL_statement
- Specifies an SQL request. Every request in the macro body must be terminated by a SEMICOLON character.
- parameter_name
- The name of a parameter that is replaced with a value during macro execution. UDT columns and TOP n operators are valid parameters.
- type_declaration
- A data definition or default definition for a parameter.
- type_attribute
- The data type attributes, such as NOT NULL, UPPERCASE, or TITLE.