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