Teradata Database Message 3649 - 3649 - Analytics Database - Teradata Vantage

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.