RE: SQL recursion

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Peter - simply upgrade to V5R4
;-)

At 01:01 AM 9/29/2006, you wrote:

> How do you get this type of statement to work?
>
> I tried (a modified version of) it on our BOM file just now, and got an
> SQL error:
>
> [SQL0346] Recursion not allowed in common table expressions.
> SQL State: 42836
> Error Code: +346
>
> Running QuantumDB connected to a V5R3M0 system, using this statement:
>
> with exploded(parent, child, qty, lvl) as
>         (select pdmnbr55, itmref55, boiqt1551
>                 from pdmdta.pdbl55pf where itmref55 <> ''
>         union all
>         select pdmnbr55, itmref55, boiqt155, lvl+1
>                 from pdmdta.pdbl55pf, exploded)
> select * from exploded
> order by pdmnbr55;
>
> Thanks,
>
> Peter Colpaert
> Application Developer
> PLI - IT - Kontich, Belgium
> -----
> Yoda of Borg are we.  Futile is resistance, assimilated will you be.
> -----