Hi,

Can anybody tell me the equivalent for Oracle Connect By & Start With Clauses used to select data with hierarchical relationships in DB2.My Query in Oracle 9i is like this:-

SELECT
code,
budgetCode,
budgetName,
groupCode
FROM
acBudgetGroup
CONNECT BY PRIOR code = groupCode
START WITH groupCode IS NULL;

Please provide me with the DB2 Equivalent.

Regards,
Mahesh

Actually I had the same problem, and the only solution I found was that: http://www-128.ibm.com/developerwork...dm-0510rielau/