Db2 insert statement having one of the columns as select statement

create procedure RUN_QUERY()
 
LANGUAGE SQL
 
BEGIN
--Declare generic variables
 
 DECLARE        v_counter               INTEGER DEFAULT 0;
 DECLARE        v_message               varchar(70);
 DECLARE        v_sqlstate              varchar(5);
 DECLARE        v_at_delete             smallint;
 DECLARE        v_start_timestamp       timestamp;
 DECLARE        v_end_timestamp         timestamp;
 DECLARE        v_procstart_timestamp   timestamp;
 DECLARE        v_procend_timestamp     timestamp;
 DECLARE        SQLSTATE                char(5);
 DECLARE        at_notfound             SMALLINT DEFAULT 0;
 DECLARE        at_null                 SMALLINT DEFAULT 0;
 
 DECLARE command1 VARCHAR(1000);
 
 
 DECLARE not_found
 CONDITION for SQLSTATE '02000';
 
 DECLARE  SQLEXEPTION
 CONDITION for SQLSTATE '23502';
 
 DECLARE CONTINUE HANDLER FOR not_found
 BEGIN
   SET at_notfound = 1;
 END;
 
 DECLARE CONTINUE HANDLER FOR SQLEXEPTION
 BEGIN
   SET at_null = 1;
 END;
   set v_procstart_timestamp = current timestamp;
   set v_start_timestamp = current timestamp;
 
   BEGIN
 DECLARE cursor1 CURSOR FOR
 SELECT QUERY1 from TEST_QUERY;
  OPEN cursor1;
  WHILE at_notfound = 0 DO
    FETCH cursor1 INTO command1;
    EXECUTE IMMEDIATE command1;
  END while;
  CLOSE  cursor1;
 
 
  set v_procend_timestamp = current timestamp;
  set v_end_timestamp = current timestamp;
 
 
INSERT INTO ERRORS VALUES('TST',current timestamp,command1,'Procedure',
                                 null,char(v_procstart_timestamp)||' '||char(v_procend_timestamp));
 
END;
 
END                     

Select allOpen in new window