AlterFsysInfoTable_TD16/AlterFsysInfoTable_ANSI_TD16 | VantageCloud Lake - AlterFsysInfoTable_TD16/AlterFsysInfoTable_ANSI_TD16 - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

The AlterFsysInfoTable_TD16 macro alters existing FsysInfo tables created in Teradata Database Releases 15.00 or 15.10.

The SQL SHOW* functions display the column MapName. AlterFsysInfoTable_TD16 converts the existing target tables created in Teradata Database 15.0 or 15.10 to include columns in the SHOWBLOCKS/SHOWWHERE SQL output. The macro creates an additional column, MapName, in the SQL SHOW* target tables.

On a Teradata Database 16.00 system, use the PopulateFsysInfoTable_TD15 macro to populate the pre-existing target table or alter the table to 16.00, and then populate the table using the new macros.

If you use ANSI session mode, use the _ANSI form of the macro.

Required Privileges

To run this macro you must have EXECUTE privileges on the AlterFsysInfoTable_TD16 macro or on the database containing the macro.

The macro name and arguments are case-insensitive.