许可授权标识 "DB2ADMIN" 使用的表空间

CREATE PROCEDURE P_TMP007 ()

    RESULT SETS 1

    LANGUAGE SQL

P1: BEGIN  

    DECLARE GLOBAL TEMPORARY TABLE TMP_007

    (

      F_GYSBH CHAR(6),

      F_WLID CHAR(6)

    )

    NOT LOGGED  with replace;

    INSERT INTO SESSION.TMP_007 VALUES ('0','0');

    INSERT INTO SESSION.TMP_007 VALUES ('0','0');

    INSERT INTO SESSION.TMP_007 VALUES ('0','0');

    INSERT INTO SESSION.TMP_007 VALUES ('0','0');

    INSERT INTO SESSION.TMP_007 VALUES ('0','0');

    INSERT INTO SESSION.TMP_007 VALUES ('0','0');

    INSERT INTO SESSION.TMP_007 VALUES ('0','0');

    INSERT INTO SESSION.TMP_007 VALUES ('0','0');

    INSERT INTO SESSION.TMP_007 VALUES ('0','0');

    P2:BEGIN  

        DECLARE C1 CURSOR WITH RETURN FOR SELECT * FROM SESSION.TMP_007;  

        OPEN C1;

    END P2;  

END P1

call DB2ADMIN.P_TMP007()