Unanswered: Procedure - for searching & inserting record
There are two tables , Table A and Table B.
I need to take the prod_num from table and search for the same in Table B. If prod_num is not found in Table B, then I need to insert the entire
record into Table B. This needs to be done for all the records..
If I declare a cursor for the Table A and variable say prod_variable for prod_num for Table B.
Can I compare values like this ?
I havent written a single procedure in DB2 so fare . so would like seek your advice ..