logo  
Google
 

DB2 SQL-Error: -109

SQLState: 42601

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.

 <-  BACK TO INDEX