Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Karachi,pakistan
    Posts
    17

    Unanswered: Alter Column Length

    I m on DB2 7.1 ,OS win2000;
    using control center i can alter the table colum lenght having VARCHAR type,but its not allow me to do the same with CHARACTER type.
    anyone know how to do it???
    tell me query as well if u know
    plz
    A.Dee

  2. #2
    Join Date
    Mar 2004
    Location
    Toronto, ON, Canada
    Posts
    513
    Quote Originally Posted by ADee
    I m on DB2 7.1 ,OS win2000;
    using control center i can alter the table colum lenght having VARCHAR type,but its not allow me to do the same with CHARACTER type.
    anyone know how to do it???
    tell me query as well if u know
    plz
    You can't change the length of a CHAR column. To do it you need to drop/recreate the table.
    --
    Jonathan Petruk
    DB2 Database Consultant

  3. #3
    Join Date
    Jan 2004
    Location
    Karachi,pakistan
    Posts
    17
    hummmm.....so suppose to do a long job...anyways Thanx alot!
    A.Dee

Posting Permissions

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