请发些DB2自定义函数的例子上来

asktime

请发些DB2自定义函数的例子上来

jiangjinlu

CREATE FUNCTION F_ORG_TS0 (I_ORGID INTEGER)
  RETURNS TABLE(RID INTEGER)
  LANGUAGE SQL
  READS SQL DATA
  NO EXTERNAL ACTION
  DETERMINISTIC
  
  RETURN  
    with rpl(orgid) as
    (
      select orgid from organization root where root.orgid=I_ORGID
      union all
      select child.orgid from rpl parent,organization child where child.parentorgid=parent.orgid
    )
    select distinct a.orgid as rid from rpl a;