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
[DBC.] { AlterFsysInfoTable | AlterFsysInfoTable_ANSI } (
'target_database_name',
'target_table_name',
{ 'SHOWBLOCKS' | 'SHOWWHERE' },
'display_opt'
)
- '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