Map Macros | SQL Operators & User-Defined Functions | Teradata Vantage - 17.10 - Map Macros - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1210-171K
Language
English (United States)

The following macros are used to add or remove databases to an exclude list.

The macros are created when the DIP script is executed and reside in the TDMaps database.
Macro Name Purpose Data Type
AddDBInExcludeList Add a database to the exclude list in SpaceExcludeDBListTbl.

User can execute this macro for databases that do not need space re-adjustments by using the AdjustSpace procedure.

VARCHAR(128) CHARACTER SET UNICODE
DelDBInExcludeList Remove a database from the exclude list in SpaceExcludeDBListTbl.

User can execute this macro for removing a database name from the exclude list so that the AdjustSpace procedure can re-adjust the space settings.

VARCHAR(128) CHARACTER SET UNICODE