Function of REPLACE MACRO Requests - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

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
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™

REPLACE MACRO executes as a DROP MACRO request followed by a CREATE MACRO request except for the handling of privileges. Vantage retains all of the privileges that were granted directly on the original macro.

If the specified macro does not exist, a REPLACE MACRO request creates it. In this case, the REPLACE request has the same effect as a CREATE MACRO request.

If an error occurs during the replacement of the macro, the existing macro remains in place as it was prior to the performance of the REPLACE MACRO request (it is not dropped). This is analogous to a ROLLBACK on the operation.