logo  
Google
 

DB2 SQL-Error: -345

SQLState: 42836

Short Description: THE FULLSELECT OF THE RECURSIVE COMMON TABLE EXPRESSION MUST BE THE UNION OF TWO OR MORE FULLSELECTS AND MUST NOT INCLUDE COLUMN FUNCTIONS GROUP BY CLAUSE HAVING CLAUSE OR AN EXPLICIT JOIN INCLUDING AN ON CLAUSE

The common table expression name includes a reference to itself and therefore: v must be the union of two or more fullselects. v cannot include a GROUP BY clause. v cannot have column functions. v cannot include a HAVING clause. v and cannot include an explicit join with an ON clause.System action: The statement cannot be executed. Programmer response: Change the common table expression by: v making it a union of two or more fullselects. v removing any column functions, GROUP BY clause, HAVING clause, or explicit JOIN including an ON clause. v removing the recursive reference.

 <-  BACK TO INDEX