SQL Used to Run a Macro - Teradata Vantage - Analytics Database

Database Introduction

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-09-27
dita:mapPath
gtm1628096154303.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dsm1472253642401
lifecycle
latest
Product Category
Teradata Vantageā„¢

To run a macro, use the EXECUTE statement.

For example, the following statement uses the NewEmp macro to insert a name, employee number, and department number into the Employee table and update the Department table.

EXECUTE NewEmp ('Goldsmith H', 10015, 600);