17.10 - 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
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-08-13
dita:mapPath
fsi1592016213432.ditamap
dita:ditavalPath
fsi1592016213432.ditaval

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;