24、函数
create function deptname(p_empid varchar(6))
returns varchar(30)
language sql
specific deptname
begin atomic
  declare v_department_name varchar(30);
  declare v_err varchar(70);
  set v_department_name = (
      select d.deptname from department d,employee e
         where d.deptno = e.workdept and e.empno = p_empid
  );
  set v_err = 'Error:employee'||p_empid||'was not found';
  if v_department_name is null then
    signal sqlstate '8000' set message_text=v_err;
  end if;
  return v_department_name;
  end
  @
  
25、触发器
create trigger reorder
after update of qty on stock
referncing new as n
for each row mode db2sql
when (n.qty<=5)
insert reorder values (n.itemno,current timestamp)


26、存储过程
create procedure tatal_raise(in p_min dec(4,2),in p_max dec(4,2),out p_total dec(9,2))
language sql
specific total_raise
begin
   -- Declare variables
   declare v_salary dec(9,2);
   declare v_bouns dec(9,2);
   declare v_raise dec(4,2);
   declare v_job varchar(15) default 'pres';
   -- declare returncode
   declare sqlstate char(5);
   
   -- procedure logic
   declare c_emp cursor for
   select salary,bouns from employee where job != v_job;
   
   open c_emp