Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2009
    Posts
    8

    Unanswered: DB2 V9.1 drop column

    Can not drop a column from a table. I do have all the relevant previlages.
    Error message
    Drop failed. Function not supported (Reason code = "100").. SQLCODE=-270, SQLSTATE=42997, DRIVER=3.57.86

    Any idea?

    Thanks

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    SQL0270N
    Function not supported (Reason code = reason-code).
    Explanation:
    The statement cannot be processed because it violates a restriction as indicated by the following reason code:
    ...
    100
    Drop column, and alter nullability is not allowed on any table with data capture on.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Jul 2009
    Posts
    8

    Accepted solution

    Figured out that was a confusion in the previlages. Unpredicted behaviour in Control Center and the IBM data studio.

    In fact it is possible to drop a column containing data. Have also noticed that column names must be in upper case otherwise everything gets very messy.

  4. #4
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    DB2 will automatically convert column names to upper case, unless you specified them as delimited names. So that shouldn't be a problem. And if you have wrong privileges, you'd get a different error. I agree with n_i that the error code tells you exactly what is wrong.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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