Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2005
    Posts
    24

    Unhappy Unanswered: How to change the table column data type in DB2 7.1 window version????

    Dear All,

    Could u pls help me this? I would like to change one of table column data type from Decimal to Integer in DB2 UDB 7.1(window version).
    I don't see any function to change in Control center or don't see the command in information center reference.
    May I know I can do that or not?
    If yes,how to do it?
    If not,is there any suggetion pls?

    Help me pls

    Thanks,

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,
    1. rename table
    2. create table with integer column definitions
    3. execute sql: insert into new_table select * from old_table.

    Hope this helps,
    Grofaty

  3. #3
    Join Date
    Aug 2005
    Posts
    24
    Thanks a lot, grofatty.
    Really appreciate your suggetion.

Posting Permissions

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