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.
Recursive queries are possible in DB2 LUW. You can google examples. I have no idea what all that means.
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)