DB2 recursive query

Recursive query for table data defined by parent-child node: DB2 recursive query with temp (id,parentid,level)
As
(SELECT id,parentid,0 from amis_wf_node WHERE parentid = ' 4028e48146a3c33d0146a3cd9e860022 '
UNION All
SELECT b.id,b.parentid,a.level+1 from temp a,amis_wf_node b WHERE a.id= B.parentid
)
SELECT * from temp; SELECT id,parentid,0 from amis_wf_node WHERE parentid = ' 4028e48146a3c33d0146a3cd9e860022 '
This sentence can also add conditions, if you want to look up from the bottom of the conditions WHERE a.id= B.parentid Exchange Order