Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230

    Unanswered: Are we able to rename a column in db2 v8 aix4.3 or 5.2?

    Hi all,
    I am working with db2 v8 fixpac 5 aix 5.2

    Thanks in advance for your help.

  2. #2
    Join Date
    Aug 2004
    Posts
    2

    Unhappy

    As far as I know - that's impossible. The only thing you can do is change the length of CHAR/VARCHAR fields.

  3. #3
    Join Date
    Apr 2004
    Location
    Inside Intel
    Posts
    165

    Talking

    You gotta drop and recreate table with the new column name.

    Newbie

  4. #4
    Join Date
    Sep 2003
    Location
    canada
    Posts
    230
    Quote Originally Posted by Brownie
    As far as I know - that's impossible. The only thing you can do is change the length of CHAR/VARCHAR fields.
    Thank you All,

    I tried to change the length of column from char(8) to char(9) I got error SQL0190N!!!!! , I know varchar is OK but char I could not.

    please advise

  5. #5
    Join Date
    Apr 2004
    Location
    Inside Intel
    Posts
    165
    I know you can do that in DB2 V8 for z/OS. I am not sure on DB2 for Windows, Unix and Linux.

    Newbie

  6. #6
    Join Date
    Feb 2002
    Posts
    96
    Yes. You are right. In LUW, only varchar length can be increased. Plse note, we can not decrease length.

    Regards
    Prakash

Posting Permissions

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