sam2929
asked on
alter table
Hi,
I have column ID as bigint not null, i want to alter it to bigint null i tried
ALTER TABLE aa alter COLUMN ID set data type BIGINT null ;
its giving me error
Explanation:
The attributes specified in the ALTER COLUMN clause for the column
"<column-name>" of the table "<table-name>" in an ALTER TABLE statement
are not compatible with the attributes of the existing column. The error
was returned for one of the following reasons.
I have column ID as bigint not null, i want to alter it to bigint null i tried
ALTER TABLE aa alter COLUMN ID set data type BIGINT null ;
its giving me error
Explanation:
The attributes specified in the ALTER COLUMN clause for the column
"<column-name>" of the table "<table-name>" in an ALTER TABLE statement
are not compatible with the attributes of the existing column. The error
was returned for one of the following reasons.
ASKER
Database server = DB2/AIX64 9.5.9
try
ALTER TABLE aa alter COLUMN ID set not null ;
ALTER TABLE aa alter COLUMN ID set not null ;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
i don't think is supported before version 9