DB2 SQL-Error: -20058
SQLState: 428EC
Short Description: THE FULLSELECT SPECIFIED FOR MATERIALIZED QUERY TABLE IS NOT VALID
The materialized query table definition has specific rules regarding the contents of the fullselect. When DISABLE QUERY OPTIMIZATION is specified, the following additional restrictions apply: v The fullselect cannot contain a reference to a created global temporary table or a declared global temporary table. v The fullselect cannot reference another materialized query table. When a materialized query table is defined with ENABLE QUERY OPTIMIZATION specified, more restrictions apply: v The fullselect must be a subselect. v The subselect cannot reference to a user-defined scalar or table function with the EXTERNAL ACTION or NON-DETERMINISTIC attributes, or built-in function RAND. v The subselect cannot contain any predicates which include subqueries. v The subselect cannot contain a nested table expression or view that requires temporary materialization. v The subselect cannot contain a join using the INNER JOIN syntax. v The subselect cannot contain an outer join. v The subselect cannot contain a special register. v The subselect cannot contain a scalar fullselect. v The subselect cannot contain a row expression predicate. v The subselect cannot contain sideway references. v The subselect cannot contain table objects with multiple CCSID sets. v The subselect cannot contain more than one table with a security label column, and the security label column must be one of the select list items of the subselect. v If the subselect references a view, the fullselect in the view definition must satisfy the above restrictions.System action: The statement cannot be processed. Programmer response: Change the fullselect in the CREATE TABLE or ALTER TABLE statement so that it conforms to the rules listed above.