Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Posts
    12

    Unanswered: How to Implement Oracle Connect By & Start With clauses in DB2 UDB V8.2

    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
    Mahy

  2. #2
    Join Date
    Mar 2006
    Posts
    14
    Actually I had the same problem, and the only solution I found was that: http://www-128.ibm.com/developerwork...dm-0510rielau/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •