Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2009
    Posts
    7

    Unanswered: Export/Import vs Rename

    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

  2. #2
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    version ?
    v 9 Luw supports

    ALTER TABLE Tab1
    ALTER COLUMN col1 SET DATA TYPE DECIMAL(14,6)
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  3. #3
    Join Date
    Sep 2009
    Posts
    7
    Also when there's data in the table/column?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •