Hi,
iam trying to alter table to change the data type of the column from Date to Timestamp, iam getting the following error

16:15:04 [ALTER - 0 row(s), 0.000 secs] [Error Code: -104, SQL State: 42601] DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: TIMESTAMP;D_TIME SET DATA TYPE;<graphic_string>

thanks in advance

That is because it is not allowed. You will have to export the data out of the table, drop the table, recreate it with the new definition, and import the data.

Note on the export, convert the date column to a timestamp in the select statement.

Andy

Alternatively, you could
(1) rename the column
(2) add a new column of type TIMESTAMP, with the old name
(3) populate the new column with a casted copy of the old column
(4) make the old column "hidden".

Change step (4) to "drop the old column" (assuming that the OP has DB2 V9.5, which supports that feature).

Not on DB2 9 for z/OS, unfortunately...

Hello
alter table tablename alter column columnname set datatype varchar(10)


but it will not work in 8.1....

this will work in 9.5

Yeah, since we don't know which version of DB2 on which platform the OP is using, we can only throw ideas around.