DB2 SQL-Error: -342
SQLState: 42925
Short Description: THE COMMON TABLE EXPRESSION MUST NOT USE SELECT DISTINCT AND MUST USE UNION ALL BECAUSE IT IS RECURSIVE
There are two possible explanations: v A fullselect within the common table expression name cannot start with SELECT DISTINCT because the common table expression is recursive. v A fullselect within the common table expression name specified UNION instead of UNION ALL as required for recursive common table expressions.System action: The statement cannot be executed. Programmer response: Remove the keyword DISTINCT from the common table expression, add the keyword ALL following UNION, or remove the recursive reference within the common table expression.