Sql Rekursiv

[Pikachu]

Ich hab hier was Cooles gefunden: Rekursives SQL

Scheint ab V5R4 zu gehen ...

WITH ABCDE (B1NR01,DATUM,B1NR02) AS (                             
     SELECT B1NR01,DATUM,B1NR02 FROM BESTELLP WHERE B1NR01=7635561
     UNION ALL                                                    
     SELECT A.B1NR01,A.DATUM,A.B1NR02 FROM BESTELLP A             
     INNER JOIN ABCDE B ON A.B1NR01=B.B1NR02)                     
SELECT * FROM ABCDE WHERE B1NR02=0