SET SCHEMA = 'ZHSQ';
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","SYSIBMADM","ZHSQ";
CREATE OR REPLACE PROCEDURE "ZHSQ"."QUERY_PICTURE" (
IN "USER_ORGS" VARCHAR(4000),
IN "BEGIN_ROW" INTEGER,
IN "END_ROW" INTEGER,
IN "ADMINTYPE" INTEGER,
IN "BASE_SQL" VARCHAR(4000),
OUT "SQL_TEXT" VARCHAR(4000) )
SPECIFIC "SQL160728011925574"
DYNAMIC RESULT SETS 2
LANGUAGE SQL
NOT DETERMINISTIC
EXTERNAL ACTION
MODIFIES SQL DATA
OLD SAVEPOINT LEVEL
B
SET CURRENT PATH = "SYSIBM","SYSFUN","SYSPROC","SYSIBMADM","ZHSQ";
CREATE OR REPLACE PROCEDURE "ZHSQ"."QUERY_PICTURE" (
IN "USER_ORGS" VARCHAR(4000),
IN "BEGIN_ROW" INTEGER,
IN "END_ROW" INTEGER,
IN "ADMINTYPE" INTEGER,
IN "BASE_SQL" VARCHAR(4000),
OUT "SQL_TEXT" VARCHAR(4000) )
SPECIFIC "SQL160728011925574"
DYNAMIC RESULT SETS 2
LANGUAGE SQL
NOT DETERMINISTIC
EXTERNAL ACTION
MODIFIES SQL DATA
OLD SAVEPOINT LEVEL
B