IBM DB2 Error Code -345 – the fullselect of the recursive common t

In this post, you’ll learn about the IBM DB2 Error -345 and the reason why you are receiving it

IBM DB2 Error Code :

-345

Reason for this Error in DB2

THE FULLSELECT OF THE RECURSIVE COMMON TABLE EXPRESSION name MUST BE A UNION ALL AND MUST NOT INCLUDE AGGREGATE FUNCTIONS, GROUP BY CLAUSE, HAVING CLAUSE, OR AN EXPLICIT JOIN INCLUDING AN ON CLAUSE