Results 1 to 3 of 3

Thread: Error

  1. #1
    Join Date
    Jan 2009
    Posts
    153

    Unanswered: Error

    Hi Experts,

    I got error when i tried a select statment on table EXICRDAPPT

    SQL0668N Operation not allowed for reason code "1" on table
    "ADMINISTRATOR.EXICRDAPPT". SQLSTATE=57016.


    Before doing this I ran a truncate table on another table.

    Please Help

    TIA

  2. #2
    Join Date
    Jan 2009
    Posts
    153
    Problem Solved

  3. #3
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    You have an RI on the table.

    You got to learn to utilize IBM to get answers to this easy question.

    Download at Least Message Ref pdf files

    IBM - DB2 9 for Linux, UNIX and Windows manuals

    Or simply go here DB2 Database for Linux, UNIX, and Windows

    and put your error code there

    or do on the command line

    db2 "? SQL0668N"


    1 Execute the SET INTEGRITY statement with the IMMEDIATE CHECKED
    option on table "<table-name>" to bring the table out of the
    Set Integrity Pending No Access state. For a user
    maintained materialized query table, execute the statement
    with the IMMEDIATE UNCHECKED option instead of the
    IMMEDIATE CHECKED option.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

Posting Permissions

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