16.20 - Example: Migrating Tables to a Prior Release - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Advanced SQL Engine
Teradata Database
Release Number
April 2020
Content Type
Programming Reference
Publication ID
English (United States)
Last Update

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;