16.20 - AlterFsysInfoTable_TD16/AlterFsysInfoTable_ANSI_TD16 - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Administration
Programming Reference
Publication ID
B035-1210-162K
Language
English (United States)

Purpose

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 Database16.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.

Syntax



'target_database_name'
The database in which the previous version of the target table exists.
You must have appropriate privileges to create tables in the target database.
'target_table_name'
The name of the target table that must be altered to have the "MapName" column in it.
You must have appropriate privileges to create tables in the target database.
'SHOWBLOCKS' or 'SHOWWHERE'
The listed SHOW* command includes a MapName column. The MapName column appears in the listed SHOW* command displays, and is populated with map name values.
'display_opt'
The level of file system detail that can be stored in the table.
  • S provides minimal amount of file system information
  • M provides a medium amount of file system information
  • L provides the maximum amount of file system information
For more information about the specific information displayed, see PopulateFsysInfoTable/PopulateFsysInfoTable_ANSI.
The display option chosen for CreateFsysInfoTable must match the display option to be used for the corresponding execution of the PopulateFsysInfoTable macro.
If output is directed to the screen (for example, empty strings are specified for database and table names), then table creation is not required using CreateFsysInfoTable or CreateFsysInfoTable_ANSI macro call. Any display option can be used.