So we built better training tools.
-Dedicated Cloud Servers
All at your fingertips. What are you waiting for?
CREATE PROCEDURE TEMP_PROC1 (IN NAMEA VARCHAR(125)) DYNAMIC RESULT SETS 1 P1: BEGIN DECLARE currentDEPT varchar(10); SET currentDEPT = 'Test'; SET CURRENT ISOLATION UR; 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 CREATOR = NAMEA; COMMIT; BEGIN DECLARE c2 CURSOR WITH RETURN FOR SELECT COL1, currentDEPT FROM SESSION.TEMP_TABLE; OPEN c2; END; END P1
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.