In this post, you’ll learn about the error message +347 the recursive common table expression name may contain an infinite loop in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
+347 the recursive common table expression name may contain an infinite loop
Reason for the Error
The recursive common table expression called name may not complete. This warning is based on not finding specific syntax as part of the iterative portion of the recursive common table expression.
Solution
To prevent an infinite loop, include the expected syntax as described.
