RE: SQL recursion

[Peter.Colpaert@xxxxxxxxx]

Vern,

Thanks (even though this was the reply I feared I'd get).

Peter Colpaert
Application Developer
PLI - IT - Kontich, Belgium
-----
Yoda of Borg are we.  Futile is resistance, assimilated will you be.
-----



Vernon Hamberg <vhamberg@xxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
29/09/2006 12:52
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc

Subject
RE: SQL recursion






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.
> -----