-109 clause-type CLAUSE IS NOT PERMITTED
Explanation
A clause was used where it is not permitted.
- clause-type
- The type of clause.
The error can be issued for reasons that include the following:
- An ALTER TABLESPACE statement with a LOGGED or NOT LOGGED clause was specified for an XML table space, which is not permitted.
- An ALTER TABLE statement specified an ALTER PARTITION clause for a table that contains an XML column, which is not permitted.
- A UNION or UNION ALL set operator is specified in a SELECT INTO statement, which is not permitted.
System action
The statement cannot be processed.
Programmer response
Correct the syntax, and reissue the SQL statement.
You can use a nested table expression to rewrite a UNION or UNION ALL set operator that is used in a SELECT INTO statement.
SQLSTATE
42601