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

Problem Solved

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.