I am trying to copy data from Table_A to Table_B for given input parameter.
How can I use the value of ID in Load cmd
CREATE OR REPLACE PROCEDURE CP
(IN ID VARCHAR(10))
LANGUAGE SQL
SPECIFIC SQL220916104128256
BEGIN
call SYSPROC.ADMIN_CMD(
'LOAD FROM (SELECT ''ID'', NAME, TYPE FROM TABLE_A) OF CURSOR INSERT INTO TABLE_B'
);
END