DB2 Copy via Load in stored procedure

Viewed 29

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
1 Answers

If I get it right you need to provide the value of ID in your query, you are now providing the string 'ID':

'LOAD FROM (SELECT ''' || ID || ''', NAME, TYPE FROM TABLE_A) OF ...
Related