Equivalent of "Connect By prior .. with level" in Teradata

UDA
Fan

Equivalent of "Connect By prior .. with level" in Teradata

There is "Connect By prior .. with level" statement in Oracle.Can anybody please tell me if there is an equivalent to this statement in Teradata.
1 REPLY
Senior Apprentice

Re: Equivalent of "Connect By prior .. with level" in Teradata

Hi Ashu,
since V2R6 there's Standard SQL "WITH" for recursive queries, most of Oracle's functionality can be converted.

There's a good article for DB2 how to convert CONNECT BY to WITH, most of it is also true for Teradata (But you have to specify "WITH RECURSIVE" instead of "WITH":
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0510rielau/

Dieter