1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39
|
@
SET SCHEMA #schema#
@
@
CREATE PROCEDURE createProfil(
INOUT iCount INT , IN iStart INT, IN iEnd INT,
IN pNomProfil VARCHAR(50),
IN pDescProfil VARCHAR(256),
IN iNumEntreprise INT,
IN iNbUtilisation INT,
IN pCodeProfilActif CHAR
)
-- qu'est ce que cela change si je mets 2 ?
DYNAMIC RESULT SETS 1
LANGUAGE SQL
BEGIN
DECLARE at_end INT;
DECLARE idCree INT;
DECLARE ID_STMT VARCHAR(100);
DECLARE curId CURSOR WITH RETURN TO CALLER FOR stmt_id;
-- je ne sais pas à quoi cela correspond?
DECLARE CONTINUE HANDLER FOR NOT FOUND
SET at_end = 1;
-- recuperation de id par magie
SELECT KPROF INTO idCree
FROM FINAL TABLE (INSERT INTO ...);
-- competement perdu
SET ID_STMT='SELECT ' || RTRIM(CAST(idCree AS CHAR(20))) || ' FROM sysibm.sysdummy1';
PREPARE stmt_id FROM ID_STMT;
OPEN curId;
END
@ |
Partager