Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2013
    Posts
    6

    Unanswered: Alter table - rename column and data type

    Hello,

    I have to rename and change the data type from Decimal to CHAR of an existing column in a table.

    Is it possible to do the change without dropping table and contraints? please advise

    version : DB2 9.1

    Thank you
    Aran

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What does the manual say?

    Andy

  3. #3
    Join Date
    Jun 2013
    Posts
    6
    I am not finding in the information what i need in all the docs i searched and read. kindly provide me the link (or) please advise whether it can done without dropping table and constraints?

    Thank you

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    It depends on the DB2 version. You can Google "db2 luw infocenter 9" and look up ALTER TABLE.

    There are different InfoCenters for DB2 LUW 9.5, 9.7, 10.1, and 10.5, so make sure you have the correct one.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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