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).