What is the equivalent of "CONNECT_BY_ISCYCLE" in Teradata
I must make a porting of a query in Oracle that it contains the CONNECT_BY.
I know that in Teradata it is replaced with the WITH RECOURSIVE, but there is also the function CONNECT_BY_ISCYCLE.
How can I replace it in TERADATA?
I report the query already migrated to Teradata, but which still contains CONNECT_BY_ISCYCLE function in the SELECT:
WITH RECURSIVE temp as (
SELECT 1 as level,CONNECT_BY_ISCYCLE ,PROVA_FICOMMO.*, PROVA_FICOMMO.FIIDNEW root_FIIDNEW, PROVA_FICOMMO.FI_DETAIL root_FI_DETAIL, PROVA_FICOMMO.MYFIID root_MYFIID FROM BFD_SSL00_APPPRD.PROVA_FICOMMO WHERE SSL_SNAPSHOT_DATE=20160503 union all select temp.LEVEL +1 ,CONNECT_BY_ISCYCLE ,PROVA_FICOMMO.*, temp.FIIDNEW root_FIIDNEW, temp.FI_DETAIL root_FI_DETAIL, temp.MYFIID root_MYFIID from temp AS a, BFD_SSL00_APPPRD.PROVA_FICOMMO AS b where a.UNDERLYINGID = b.FIIDNEW