Examples of how to run Stored Procedures or Dynamic compound statements in Netbeans IDE Database Service

Dynamic compound statements.sql

DELIMITER //
BEGIN 
  CREATE TABLE QTEMP.TEST1 AS (SELECT * FROM MYLIB.MYTABLE)
  WITH DATA;
  CREATE TABLE QTEMP.TEST2 AS (SELECT * FROM MYLIB.MYTABLE)
  WITH DATA;
END //
DELIMITER ; 
SELECT * FROM QTEMP.TEST2; 
SELECT * FROM QTEMP.TEST3;

StoredProcedureExampleIBMiDb2fori.sql

DELIMITER //
CREATE PROCEDURE MYSTOREDPROC (IN MYPARAM VARCHAR(20))
    LANGUAGE SQL 
    DYNAMIC RESULT SETS 1
BEGIN 
    DECLARE c1 CURSOR FOR 
       SELECT * 
          FROM MYATABLE 
          WHERE FIELD = MYPARAM;
    OPEN c1;
END //
DELIMITER ; 
Call MYSTOREDPROC('test');