-769   SPECIFICATION OF CREATE AUX TABLE DOES NOT MATCH THE CHARACTERISTICS OF THE BASE TABLE

Explanation

Either an attempt was made to create an auxiliary table
  • using the PART clause and the specified base table is not partitioned or
  • without using the PART clause and the specified base table is partitioned
If 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.

SQLSTATE

53096