5,889
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE DB2ADMIN.PRO_SELECT ( )
------------------------------------------------------------------------
-- SQL 存储过程
------------------------------------------------------------------------
DYNAMIC RESULT SETS 1
language sql
P1: BEGIN
DECLARE C1 CURSOR WITH RETURN TO CLIENT FOR
SELECT * FROM DB2ADMIN.STUFF;
OPEN C1;
END P1
proc = conn.prepareCall("{call proc_select()}");
proc.execute();