Hi all,
i'm working on a project and i need to change in a table of the db the data-type of a column this column is type Decimal(19,2) and i need to change it in Varchar(512) without drop and rebuild the table or the column.

it is possible to do it with a query in DB2? (like alter table .... alter .... set data type...)

If yes can you write me the query?
thx

No, you cannot alter a column from decimal to varchar.

If you use the Control Center to modify a column, it executes a procedure that extracts the data, drops the table, recreates the table, and reloads the data (or you can write your own script to do the same).

ok thx a lot