DB2 SQL-Error: -766
SQLState: 560A4
Short Description: THE OBJECT OF A STATEMENT IS AN AUXILIARY TABLE FOR WHICH THE REQUESTED OPERATION IS NOT PERMITTED
An auxiliary table was named in one of the following statements: v ALTER TABLE v CREATE ALIAS v CREATE FUNCTION v CREATE SYNONYM v CREATE VIEW v DELETE v DESCRIBE TABLE v INSERT v SELECT v UPDATE There are no attributes of an auxiliary table that can be altered. Aliases and synonyms cannot be created on an auxiliary table. Data in an auxiliary table cannot be accessed by specifying the auxiliary table name in the SELECT, INSERT, DELETE, UPDATE, CREATE PROCEDURE, or CREATE FUNCTION statement. Data in an auxiliary table can only be accessed through operations on the base table columns. Additionally, do not specify CLUSTER on ALTER TABLE if the table is an auxiliary table. System action: The statement cannot be executed. Programmer response: Correct the statement to specify the corresponding base table instead of the auxiliary table and resubmit the statement.