The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
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
|db2 z/os V10 access path||7||345|
|DB2, how do I FETCH 1 ROW from a table inside a subselect ?||22||940|
|DB3-913 err can anyone plz help to solve this issue||3||242|
|How to conver to Hijri date in SSRS||6||207|