Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    138

    Unanswered: Column data type

    db2 Vesrion --8.1 fixpack 5
    Platform -AIX
    how can I change column data type from char to varchar for multiple columns at same time..I have like 200+ columns. I need to change every column data type from char to varchar

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    I'm not sure if it's at all possible, even for a single column... You'll have to re-create tables...

Posting Permissions

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