CREATE PROCEDURE "COGNOSTEST3" ( )
LANGUAGE SQL
NOT DETERMINISTIC
CALLED ON NULL INPUT
EXTERNAL ACTION
OLD SAVEPOINT LEVEL
MODIFIES SQL DATA
INHERIT SPECIAL REGISTERS
BEGIN
declare SQLCODE INT DEFAULT 0;
DECLARE SQLSTATE CHAR(5);
DECLARE new_culown varchar(4000);
DECLARE new_case varchar(4000);
DECLARE last_case varchar(4000);
DECLARE newsql varchar(4000);
DECLARE v_iquestionid varchar(200);
DECLARE v_ianswerid varchar(200);
DECLARE at_end INT DEFAULT 0;
DECLARE at_end2 INT DEFAULT 0;
DECLARE C1 CURSOR FOR
select distinct iquestionid iquestionid from VIEW_NEW_DIM where Squestiontype=1 ;
DECLARE C2 CURSOR FOR
select ianswerid from VIEW_DIM_QUESTION where iquestionid =v_iquestionid; --此v_iquestionid 来自于上面SQL的v_iquestionid<