使用DB2的with as 语句 实现树的递归查询

WITH n(brno) AS 
   (SELECT brno 
      FROM org_bctl
      WHERE brno = '11010'
    UNION ALL
    SELECT nplus1.brno
      FROM org_bctl as nplus1, n
      WHERE n.brno = nplus1.sbrno)
select * from nWITH n(brno) AS 
   (SELECT brno 
      FROM or