DB2 SQL-Error: -109
Short Description: CLAUSE IS NOT PERMITTED C E SQL INPUT SEQUENCE INSERT A SET DATA TYPE ALTER TABLE I CREATE INDEX CREATE TABLE CREATE TABLESPACE ALTER TABLESPACE SQL R S T P C SQL
The indicated clause is not permitted in the context in which it appears in this SQL statement for the following reasons: v A subselect cannot have an INTO clause. v A CREATE VIEW statement cannot have INTO, ORDER BY, or FOR UPDATE clauses. v A SELECT INTO statement cannot have ORDER BY or FOR UPDATE clauses. v SELECT statements used in cursor declarations cannot have an INTO clause. v A SELECT INTO statement cannot specify KEEP UPDATE LOCKS, except in USE AND KEEP UPDATE LOCKS. v A RAISE_ERROR function can only be used as a select list item if it is cast to some data type using the CAST specification. v DESCRIBE INPUT statement can not have USING clause. v QUERYNO cannot be specified as part of an EXPLAIN statement when the EXPLAIN statement contains an Â’explainable-sql-statementÂ’. v The table being updated in a POSITIONED UPDATE statement cannot be assigned a correlation name.