Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers. It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.
CREATE PROCEDURE TEMP_PROC1 (IN NAMEA VARCHAR(125)) DYNAMIC RESULT SETS 1 P1: BEGIN DECLARE GLOBAL TEMPORARY TABLE SESSION.TEMP_TABLE (COL1 VARCHAR(125) ) ON COMMIT PRESERVE ROWS NOT LOGGED WITH REPLACE; INSERT INTO SESSION.TEMP_TABLE SELECT NAME FROM SYSIBM.SYSTABLES WHERE NAME = NAMEA; COMMIT; BEGIN DECLARE c2 CURSOR WITH RETURN FOR SELECT COL1 FROM SESSION.TEMP_TABLE; OPEN c2; END; END P1
Join the community of 500,000 technology professionals and ask your questions.