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

Teradata Vantage™ - SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Administration
Programming Reference
Publication ID
B035-1210-162K
Language
English (United States)

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;