Community

Hierarchical Queries with DB2 Connect By

(Birgitta Hauser) According to the SQL Standard, hierarchical (e.g. organization charts, bill of materials) or bi-directional data (e.g. flight connections) can be evaluated by using a recursive common table expression (RCTE). RCTEs were delivered with release V5R4 of DB2 for i.

Read More - Register for Free Membership

Tags: