Hi,

I want to use the load statement in db2 stored procedure. i just want to insert the data from one table to another table using load to increase the performance.

I tried using like this it is throwing error
BEGIN
DECLARE CURSOR_LOAD CURSOR WITH RETURN FOR
SELECT * FROM SESSION.TEMP_DA TELOAD1

CALL SYSPROC.ADMIN_C MD('LOAD CURSOR_LOAD OF CURSOR INSERT INTO SESSION.TEMP_DA TALOAD1 NONRECOVERABLE' );...