Re: BOM Explosion

Bob Voltz wrote:

Your solution gives me the following error:

SQL State: 42836
Vendor Code: -346
Message: [SQL0346] Recursion not allowed for common table expressions. Cause . . . . . : The common table expression
specified is not valid. The subselect for table TEMP_PSTRUC
refers to itself. Recursive common table expressions are not
allowed. Recovery . . . : Change the common table expressions
to refer to a table that exists or a common table expression
that has already been defined. Try the request again.

Processing ended because the highlighted statement did not
complete successfully

That error would be expected on v5r3 and prior, since recursive queries were not yet supported [on those no longer supported releases]. I believe the same error may be issued at v5r4 and later releases, for any specific restrictions for which recursion is not allowed. IIRC any query which is directed to CQE, instead of being run with the SQE, will not support recursion. The primary considerations for enabling SQE are to query the TABLE directly [i.e. only physical file, not any logical file] and must perform without character data conversion requirements [for example,
avoiding functions like UPPER() and shared weight collation].

Regards, Chuck