START WITH..... CONNECT By clause

krReddy · #1 (**permalink**) 06-19-07, 03:38

Is there any equivalent for 'Oracles start with..connect by' clause in DB2

ARWinner · #2 (**permalink**) 06-19-07, 08:08

For those of us who do not know oracle, it would be helpful if you tell us what it does. Also include which Db2 version and OS you are using.

Andy

n_i · #3 (**permalink**) 06-19-07, 12:17

If I'm not mistaken, that is Oracle's approach to recursive queries. Google or browse Graeme Birchall's DB2 SQL Cookbook (http://mysite.verizon.net/Graeme_Birchall/id1.html) for DB2-specific examples.

stolze · #4 (**permalink**) 06-25-07, 06:04

Serge Rielau wrote a nice article explaining how to port Oracle's CONNECT BY stuff to DB2 (which is standard-conforming).

Internet Services

Web Development

Digital Marketing

Consumer Tech