I tried to export table from SQL store procedure and I got this error.
SQL0104N An unexpected token "EXPORT TO lxxx OF DEL" was found following "UMMY1; END; ". Expected tokens may include: "<psm_for>". LINE NUMBER=20. SQLSTATE=42601
Here is my procedure:
CREATE PROCEDURE UFHDBTBL.Proc2 ( IN a_table_name VARCHAR(100),
IN a_table_column varchar(9000),
IN a_stmtSelect varchar(3000),
OUT stmt VARCHAR(4000),
OUT SQLSTATE_OUT char(5),
OUT SQLCODE_OUT int )
LANGUAGE SQL
------------------------------------------------------------------------
-- SQL Stored Procedure
------------------------------------------------------------------------
P1: BEGIN
DECLARE SQLSTATE CHAR(5) DEFAULT '00000';
DECLARE SQLCODE INT DEFAULT 0;
DECLARE EXIT HANDLER FOR SQLEXCEPTION
BEGIN
SELECT SQLSTATE, SQLCODE INTO SQLSTATE_OUT, SQLCODE_OUT FROM SYSIBM.SYSDUMMY1;
END;
EXPORT TO lxxx OF DEL SELECT * FROM sample_table;
SET SQLSTATE_OUT = SQLSTATE;
SET SQLCODE_OUT = SQLCODE;
END P1
Where could be a problem?