Thanks I hadc a look at the zipped html docs. Looks like a cool and
relatively easy to code feature. I'm not entirely clear what it gives over
and above the connect by construct though.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Blair Kenneth Adamache" <adamache_at_ca.ibm.com> wrote in message
news:3B24B95E.A4834587_at_ca.ibm.com...
> The PDF works. I'll get the HTML working.
>
> Niall Litchfield wrote:
>
> > I tried to and got
> >
> > The Net.Data ODBC language environment could not allocate the
environment
> > handle
> >
> > oh well try again later. !!
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > "Blair Kenneth Adamache" <adamache_at_ca.ibm.com> wrote in message
> > news:3B243445.E53F5D19_at_ca.ibm.com...
> > > See appendix M of the SQL Reference, at this page:
> > >
> >
http://www-4.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/v7pubs.d
> > 2w/en_main
> > >
> > > There are three examples, and it talks about controlling depth.
Recursive
SQL
> > > has been in DB2 since 1995.
> > >
> > > Mark Townsend wrote:
> > >
> > > > in article B749727F.1536B%markbtownsend_at_home.com, Mark Townsend at
> > > > markbtownsend_at_home.com wrote on 6/10/01 6:52 PM:
> > > >
> > > > >> WITH RPL (PART, SUBPART, QUANTITY) AS
> > > > >> ( SELECT ROOT.PART, ROOT.SUBPART, ROOT.QUANTITY
> > > > >> FROM PARTLIST ROOT
> > > > >> WHERE ROOT.PART = '01'
> > > > >> UNION ALL
> > > > >> SELECT CHILD.PART, CHILD.SUBPART, CHILD.QUANTITY
> > > > >> FROM RPL PARENT, PARTLIST CHILD
> > > > >> WHERE PARENT.SUBPART = CHILD.PART
> > > > >> )
> > > > >> SELECT DISTINCT PART, SUBPART, QUANTITY
> > > > >> FROM RPL
> > > > >> ORDER BY PART, SUBPART, QUANTITY
> > > >
> > > > Hmm - actually, there is more to this than I first saw - presumably
this
> > > > iterates down through all levels of child ? How is this transformed
?
Can
> > > > you push predicates into the traversal ? This may be way cool.
> > >
>
Received on Mon Jun 11 2001 - 09:27:37 CDT
