Document Type | Troubleshooting
Category | Administration/Configuration
Applicable Product Versions | 5SP1FS01, 5SP1FS02, 5SP1FS03, 5SP1FS04, 5SP1FS06, 6FS01, 6FS02, 6FS03, 6FS04, 6FS05, 6FS06, 6FS07
Error Code | 7080
Document Number | TADTS001
Issue
This explains the 7080 error message that may occur when changing a column type.
Note7080 error message: Specified column ‘ ’ must be empty before changing datatypes.This issue is resolved in Tibero 7 FS02; for earlier versions, please refer to the solution below.
Tibero6 FS07_CS_2005
This can occur when changing a column type from Varchar(byte) to varchar(char).
SQL> create table t2 (c1 varchar(20 char));
Table 'T2' created.
SQL>
SQL> insert into t2 values('abcdefghij');
1 row inserted.
SQL> commit;
Commit completed.
SQL> alter table t2 modify(c1 varchar(1000 byte));
TBR-7080: Specified column 'T2'.'C1' must be empty before changing datatypes.
Cause
Tibero6 FS07_CS_2005 and earlier versions
This occurs when the character length semantics specified for a varchar column at table creation differ from those used when performing a modify column on that same column, and the table contains data.
Solutions
Change the column to use the same character length semantics as specified when the table was created.
The example solution below applies to the symptom example shown above.
alter table t2 modify(c1 varchar(1000 char)); >> Table 'T2' altered.
NoteThis error does not occur if the table contains no data.