AlterFsysInfoTable_TD16/AlterFsysInfoTable_ANSI_TD16 Macros | Teradata Vantage - AlterFsysInfoTable_TD16/AlterFsysInfoTable_ANSI_TD16 - Advanced SQL Engine - Teradata Database

SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2023-04-27
dita:mapPath
fsi1592016213432.ditamap
dita:ditavalPath
fsi1592016213432.ditaval
dita:id
B035-1210
lifecycle
previous
Product Category
Teradata Vantage™

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

In addition to the privileges mentioned previously, 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.

Syntax

[DBC.] { AlterFsysInfoTable | AlterFsysInfoTable_ANSI } (
  'target_database_name',
  'target_table_name',
  { 'SHOWBLOCKS' | 'SHOWWHERE' },
  'display_opt'
)

Syntax Elements

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