Archives of the TeradataForum
Message Posted: Wed, 15 Sep 2004 @ 12:03:28 GMT
| Subj: | | Re: CONNECT BY ..START WITH ( Equivalent in Teradata ) |
| |
| From: | | Dieter Noeth |
Kallarakkal, Baburaj (B.) wrote:
| | Is there any CONNECT BY START WITH Equivalent in Teradata which is used for hierarchial listing of the rows?. | |
The only way is a SP doing the loop, check the "manufacturing" database from the demo version for an example...
| | Any NCR folks can say if this functionality might be expected in some near future in some teradata versions to be released?. | |
WITH syntax including recursive queries is announced for V2R6 (syntax from ANSI SQL similar to DB2).
Dieter
| 
