REPLACE PROCEDURE a.LOAD_TB_BI_TABLE
IN P_JOB VARCHAR(10000),
OUT P_RETURN_MSG1 VARCHAR(256),
OUT P_STATUS1 INTEGER
DECLARE v_SQL_STMT VARCHAR(10000) ;
DECLARE FLAG VARCHAR(10000) ;
DECLARE p_return_msg VARCHAR(256) ;
DECLARE p_status INTEGER ;
SET v_SQL_STMT='CALL a.LOAD_TB_BI_TABLES('||1||','||'DIM_REFRESH'||','||'DIM_REFRESH'||','||1||','||1||',P_RETURN_MSG,P_STATUS)';
Call DBC.SYSEXECSQL( :v_SQL_STMT);
SET P_RETURN_MSG1 =P_RETURN_MSG;
This is the procedure which I am creating to call another procedure, But while calling, it is throwing an error saying SQL statement not supported.
Please help, how to implement this scenaio, I need to parameteriize the store procedure name and call that within a procedure.