DB2存储过程，实现添加操作之后，返回结果集

原创于 2023-06-16 11:24:41 发布

· 222 阅读

0 ·

版权

文章标签：

#数学建模 #java #python

存储过程

通过返回查询结果证明是

否讲添加语句执行成功

CREATE OR REPLACE PROCEDURE BGTAMSLZ00.MAT_NO_ADD_0004(
IN IN_MAT_NO_LIST VARCHAR(999))

RESULT SETS 1
BEGIN
DECLARE RESULT_SET CURSOR WITH RETURN FOR
SELECT  '添加成功' AS A1
FROM  SYSIBM.SYSDUMMY1;


FOR V AS
SELECT MAT_NO FROM (
VALUES  10308329382,10308329383,10308329384,10308329385,10308329386,10308329387,10308329388,10308329389,10308329390,10308329391,10308329392,10308329393,10308329394,10308329395,10308329396,10308329397,10308329398,10308329399,10308329400,10308329401 
) A(MAT_NO)
DO
INSERT INTO
TABLE01 (REC_ID,DATE_PRC,MAT_NO) 
VALUES(666,'666',MAT_NO);
END FOR;

OPEN RESULT_SET;
END