logo  
Google
 

DB2 SQL-Error: -769

SQLState: 53096

Short Description: SPECIFICATION OF CREATE AUX TABLE DOES NOT MATCH THE CHARACTERISTICS OF THE BASE TABLE

Either an attempt was made to create an auxiliary table v using the PART clause and the specified base table is not partitioned or v without using the PART clause and the specified base table is partitionedIf the base table is not partitioned, then the PART keyword is not allowed on the CREATE AUXILIARY TABLE statement. If the base table is partitioned, then the PART keyword must be specified. System action: The auxiliary table was not created. Programmer response: Check whether the name of the base table specified in the CREATE AUXILIARY TABLE statement is correct. If it is correct and the table is not partitioned, remove the PART clause from the statement. If it is correct and the table is partitioned, add the PART clause to the statement. If the table name is not correct, correct the name and also check that the correct column name is specified.

 <-  BACK TO INDEX