logo  
Google
 

DB2 SQL-Error: -270

SQLState: 42997

Short Description: FUNCTION NOT SUPPORTED C T XML S T P A I XML XML XML S

The statement cannot be processed because it violates one or more of the following restrictions: v For an ALTER TABLE statement that names a materialized query table, the alterations are limited to either: – Changing materialized query table attributes, or turning the materialized query table to a base table, or – Using AUDIT, DATA CAPTURE, and ADD or DROP RESTRICT ON DROP clauses,(but not both in the same statement). v For the ALTER TABLE, CREATE TABLE, or CREATE INDEX statement, a BINARY or VARBINARY column cannot be specified in a partitioning key, v For the ALTER TABLE ALTER COLUMN SET DATA TYPE statement, when the column is a partitioning key column and the existing data type is CHAR or VARCHAR FOR BIT DATA, the new data type can not be VARBINARY or BINARY. v The length of the column for a base table cannot be altered if that base table is referenced by a materialized query table definition. v A materialized query table cannot be renamed.

 <-  BACK TO INDEX