Hi,

I have problems with this sql statement.


Table = emaila01
colum
evname enname
AAA--------BBB
AAA--------CCC
AAA--------DDD
CCC--------EEE
DDD--------FFF


sqlstring3 = "with temp (enname) as " _
& "(select distinct evname " _
& "from emaila01 " _
& "where evname = 'AAA' " _
& "union all " _
& "select c.enname" _
& "from emaila01 c, temp p " _
& "where p.enname = c.evname) " _
& "select distinct enname from temp"


The answer must be

BBB
CCC
DDD
EEE
FFF


What is wrong?

Reinhard

It's an infinite loop, no? You get ('DDD','AAA'), then 'AAA','DDD' which re-matches 'DDD','AAA'... forever.

Hi,

why the DBS/AS400 have not a statement for the recursive sql-select?

In ORACLE SQL I have the "connect by prior" statement.


greetings

ReinhardN