Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008

    Unanswered: Alter Column Size For Data Type -clob

    Iam using DB2 8.1, I was trying to increase the column size of type CLOB.
    iam getting the following error msg
    [Error Code: -104, SQL State: 42601] DB2 SQL error: SQLCODE: -104, SQLSTATE: 42601]

    any information abt how to alter the column size of type CLOB will be helpful.
    thanks in advance.

  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    If you tried reading the manual you would discover that it is not possible. You will have to re-create the table.
    "It does not work" is not a valid problem statement.

Posting Permissions

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