Figure 3: Multiple SQL statements for extract and populate

DECLARE CURSOR cur1 FOR 
  SELECT col1, col2, col3, col5, col7, col8
    FROM tab1
   WHERE tranId=1234 AND tranDate = ‘2007/04/20’;
OPEN cursor1;
Do
  FETCH cursor1 INTO :var1, :var2, :var3, :var5, :var7, :var8;
  INSERT INTO target 
      VALUES(:var1, :var2, :var3, :var5, :var7, :var8 );
Until no more records found  ;
CLOSE cursor1;