If the table created in Teradata Database Release 16.00 with the updated PopulateFsysInfoTable macro is migrated to Release 15.00 or 15.10, is it not possible to populate the table using the old macros.
The following error displays:
BTEQ -- Enter your SQL request or BTEQ command: exec dbc.PopulateFsysInfoTable('CallData', 'Weekly', 'showblocks', 's', 'SystemInfo', 'SHOWB_S' ); exec dbc.PopulateFsysInfoTable('CallData', 'Weekly', 'showblocks', 's', 'SystemInfo', 'SHOWB_S' ); *** Failure 3812 POPULATEFSYSINFOTABLESP:The positional assignment list has too few values. *** Total elapsed time was 5 seconds.
You can still query the table to get historical SHOWBLOCKS or SHOWWHERE data. However, the new tables must be created and then populated, or you can alter the existing tables manually to drop the "MapName" column before populating SHOWBLOCKS or SHOWHERE data. The alter table statement is as follows:
ALTER TABLE SystemInfo.SHOWB_S drop MapName;