Teradata Database Message 3558 - 3558 - Analytics Database - Teradata Vantage

Teradata® VantageCloud Lake - Analytics Database Messages

Edition
Lake
Product
Analytics Database
Teradata Vantage
Published
October 2022
Language
English (United States)
Last Update
2024-02-26
dita:mapPath
tzr1629746512312.ditamap
dita:ditavalPath
ft:empty
dita:id
vza1585613049811
lifecycle
latest
Product Category
Teradata® Vantage™
Message
Cannot alter the specified attribute(s) for %VSTR.
Explanation
Most column attributes cannot be modified after the column is created. Exceptions are those attributes which can be changed without changing the internal storage of the data. Please refer the Teradata SQL Reference : Data Definition Statements. For V2R6.2, the COMPRESS attribute for existing column(s) can be changed with the ALTER TABLE <table name> ADD <column name> COMPRESS command option. Example: ALTER TABLE Tab1 ADD Column1 COMPRESS('OldValue1', 'OldValue2', 'NewValue1', 'NewValue2'); NOTE that the new Compress list REPLACES the old list.
Generated By
OPT modules.
For Whom
End User.
Notes
Usually, if the modification causes all existing rows to be updated or invalidated, the modification is not allowed.
Remedy
If the attribute needs to be modified, the user may need to create a new table.