Recursive query of DB2

In DB2, SQL statements can be used for Recursive queries. With Statement

1. Create a tree table first:

Create   Table TST (
ID Integer ,
Parentid Int ,
Name Varchar ( 20 ))

2. Insert dataInsert   Into Tst Values  
( 1 , 0 , ' A ' ),
( 2 , 0 , ' B ' ),
( 3 , 1 , ' C ' ),
( 4 , 1 , ' D ' ),
( 5 , 4 , ' D ' ),
( 6 , 5 , ' D ' )

3. recursive query With RPL (ID, parentid, name) As  
(
Select ID, parentid, name From Tst Where Parentid = 1  
Union   All  
Select Child. ID, child. parentid, child. Name From RPL parent, TST child Where Parent. ID = Child. parentid
)
Select   *   From RPL

This statement is available in DB2 7 and only appears in sql2005.