Dear all,

I am just thinking about how to change a decimal column from 9,6 to 14,6 when the table is loaded with around 1 million observations.

I could do this via something like

create table_temp like table_old
alter table_temp alter column c1 set data type decimal(14,6)
insert into table_temp select * from table_old
drop table_old
rename table table_temp to table_old

or just use EXPORT/IMPORT

Performance of this operation is not of relevance - is there a reason to use EXPORT/IMPORT in this case? I don't see any.

What's your opinion?

Thanks,
Tom

version ?
v 9 Luw supports

ALTER TABLE Tab1
ALTER COLUMN col1 SET DATA TYPE DECIMAL(14,6)

Also when there's data in the table/column?