Re: DB2 SQL table change efficiency

Sounds like you're trying to do

CREATE TABLE ROB/MO (MYDATE CHAR (10 ) NOT NULL WITH DEFAULT)

INSERT INTO ROB/MO (MYDATE) VALUES('2014-10-21')

alter table rob/mo
alter column mydate set data type date

Message ID . . . . . . : SQL0190 Severity . . . . . . . : 30
Message type . . . . . : Diagnostic

Message . . . . : Attributes of column MYDATE in MO in ROB not
compatible.
Cause . . . . . : The attributes specified for column MYDATE in MO in
ROB
are not compatible with the attributes of the existing column. Either
the
data type, the length, or the clause is not valid.
-- A character column cannot be changed to a DATE, TIME, TIMESTAMP, or a
numeric column.


Rob Berendt