Getting error whle changing the Datatype of a column in the table.

[Rahul B]

I am new at DB2 . so please guide

I am trying to change the Datatype of a column in the table.

CREATE TABLE testschema.player (
NAME VARCHAR(120) NOT NULL,
country VARCHAR(80) NOT NULL,
club VARCHAR(120) ,
totalgoals SMALLINT not null with DEFAULT 0 ,
goalsinpresentseason SMALLINT not null with DEFAULT 0 ,
posn VARCHAR(8) not null ,
jerseyno SMALLINT ,
valueinmilliondollars Decimal(5,2)
)
/

alter table testschema.player alter column posn set data type VARCHAR(2)

but i am getting the error saying
LTER TABLE "TESTSCHEMA.PLAYER" specified attributes for column "POSN" that are not compatible with the existing column.

please help

[r035198x]

I am new at DB2 . so please guide

I am trying to change the Datatype of a column in the table.

CREATE TABLE testschema.player (
NAME VARCHAR(120) NOT NULL,
country VARCHAR(80) NOT NULL,
club VARCHAR(120) ,
totalgoals SMALLINT not null with DEFAULT 0 ,
goalsinpresentseason SMALLINT not null with DEFAULT 0 ,
posn VARCHAR(8) not null ,
jerseyno SMALLINT ,
valueinmilliondollars Decimal(5,2)
)
/

alter table testschema.player alter column posn set data type VARCHAR(2)

but i am getting the error saying
LTER TABLE "TESTSCHEMA.PLAYER" specified attributes for column "POSN" that are not compatible with the existing column.

please help

Do you have a view on your table? You may need to drop that first.
Which version are you using?

[Rahul B]

Do you have a view on your table? You may need to drop that first.
Which version are you using?

There is no view corresponding to that table
using DB2 9