Re: BOM Explosion

[CRPence <CRPbottle@xxxxxxxxx>]

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