Teradata Database Message 3649 - 17.10 - 3649 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
Message
Compressed NULL and NOT NULL cannot coexist for column %VSTR.
Explanation
A NOT NULL column cannot specify the COMPRESS attribute with no value. A column which specifies COMPRESS with no value cannot be altered to NOT NULL.
Generated By
OPT modules.
For Whom
End User.
Notes
None
Remedy
If the column does not exist yet, remove the COMPRESS option or indicate a value to be compressed. Otherwise, (1) if the table is empty, replace the column with ALTER TABLE DROP first, then ALTER TABLE ADD to recreate the column properly, (2) if the table is not empty, create a new table with proper definition, reload data from the old table to the new table, and then drop the old table.