DB2存储过程简单的模板@适合小白

只标出在命令行写的部分，其他的都是系统生成的，提醒下：db2和Oracle语法是不同的（比如在参数方面就不同）

这是最简单的存储过程了，作为小白的我写的。

SET SCHEMA DB2ADMIN;

SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","SYSIBMADM","DB2ADMIN";

CREATE PROCEDURE "DB2ADMIN"."PROC_PAY_LN_AR_SMY"
 (IN "IS_DATE" VARCHAR(10),
  OUT "RET" INTEGER
 )
  SPECIFIC "DB2ADMIN"."SQL140408102239300"
  LANGUAGE SQL
  NOT DETERMINISTIC
  CALLED ON NULL INPUT
  EXTERNAL ACTION
  OLD SAVEPOINT LEVEL
  MODIFIES SQL DATA
  INHERIT SPECIAL REGISTERS
  BEGIN
 
  COMMIT;
  TRUNCATE TABLE  DB2ADMIN.PAY_LN_AR_SMY  IMMEDIATE;
 
INSERT INTO DB2ADMIN.PAY_LN_AR_SMY
SELECT
B.OU_CODE,
c.code,
IS_DATE,
A.*
FROM DB2ADMIN.BDW_LN_AR_SMY A
left join DB2ADMIN.BDW_DIM_OU B ON A.acg_sbj_id=b.ou_ip_id
left join db2admin.STD_REF_BANK c on a.ccy_id=c.code;

 SET RET=1;

END;