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' );
END;
Please help me is there any alternate solution for using this load.
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' );
END;
Please help me is there any alternate solution for using this load.