logo  
Google
 

DB2 SQL-Error: -669

SQLState: 42917

Short Description: THE OBJECT CANNOT BE EXPLICITLY DROPPED REASON C E SQL

The DROP statement failed for the reason indicated by the reason-code as follows: 0001 The DROP TABLE statement attempted to drop a table that resides in a partitioned table space. 0002 The DROP INDEX statement attempted to drop an index required to enforce the primary key, unique key, or referential constraint of the table.System action: The statement cannot be processed. The object is not dropped. Programmer response: If the statement is a DROP TABLE statement, the table of a partitioned table space can only be dropped implicitly when the table space itself is dropped. If the statement is a DROP INDEX statement and you do not want to keep the primary key, unique key, or referential constraint, use the DROP CONSTRAINT clause of the ALTER TABLE statement to remove the

 <-  BACK TO INDEX