ALTER TABLE on UNICODE character type issue

Database
Highlighted
Teradata Employee

ALTER TABLE on UNICODE character type issue

Hi,

I am trying to EXTEND the length of datatype varchar of unicode character set from existing 18 to 40. However, it is giving me an error

3558 Cannot alter the specified attribute(s) for %VSTR.

It displays the same error on an empty table. 

I am using TD 15.00. 

Has anyone faced this issue? Does anyone know the solution on this?

Thanks,

2 REPLIES
Teradata Employee

Re: ALTER TABLE on UNICODE character type issue

Are you specifying additional attributes in the ALTER besides the VARCHAR(40)?

I believe this check only looks at which attributes are supplied in the DDL, and fails if you specify any attribute that is not legal to ALTER - even if the value supplied matches the existing definition.

Teradata Employee

Re: ALTER TABLE on UNICODE character type issue

Thanks,

It worked when I included all the attributes/constraints in the ALTER Table statement.

Ani.