15.00 - 3649 Compressed NULL and NOT NULL cannot coexist for column %VSTR. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

3649 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.

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.