求db2存储过程简单的例子

CREATE PROCEDURE sales_status
(IN quota INTEGER, OUT sql_state CHAR(5))
DYNAMIC RESULT SETS 1
LANGUAGE SQL
BEGIN
DECLARE SQLSTATE CHAR(5);
DECLARE rs CURSOR WITH RETURN FOR
SELECT sales_person, SUM(sales) AS total_sales
FROM sales
GROUP BY sales_person
HAVING SUM(sales) > quota;
OPEN rs;
SET sql_state = SQLSTATE
END @
-----------
这个过程称为SALES_STATUS，它接受一个输入参数quota 并返回输出
参数sql_state。过程体中只有一个SELECT 语句，它返回销售总量超过指定额
度的销售人员的姓名和销售总量。
----------
执行存储过程
DB2 CALL sales_status (25, ?)