Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2016
    Posts
    2

    Unanswered: Recursive Queries with DB2 LUW 10.5

    Hi,

    just wanna check if it is possible to do:
    1. recursive Queries (With - Union ALL) Statements with Search and Cycle in Db2 LUW 10.5
    2. recursive Queries (Start With - Connect by) Statements in DB2 LUW 10.5
    3. Are recursive Queries (Start With - Connect by) faster than recursive Queries (WITH - Union All)? Or is it the same and Connect-by-Queries are just syntactical sugar.

    Thanks and Regards,

    Raymond

  2. #2
    Join Date
    Jan 2003
    Posts
    4,286
    Provided Answers: 5
    Recursive queries are possible in DB2 LUW. You can google examples. I have no idea what all that means.

    Andy

  3. #3
    Join Date
    Apr 2016
    Posts
    2
    Quote Originally Posted by ARWinner View Post
    Recursive queries are possible in DB2 LUW. You can google examples. I have no idea what all that means.

    Andy
    I know that .. It is a special question about the Options "Search Depth" and "Cycle" in the "UNION ALL" recursive method.(First Question)
    Also there is a method in DB2 for i: Recursive Queries with "Start with" and "Connect by" which i wanted to try out in DB2 LUW. (Second Question)

    Thanks and Regards,

    Raymond

  4. #4
    Join Date
    Jan 2003
    Posts
    4,286
    Provided Answers: 5
    DB2 LUW has no such constructs.

    Andy

Tags for this Thread

Posting Permissions

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