Update DML handler
The next step is to run the following SQL
statements to execute Update DML at the source database table:
-- connect strmadm/strmadm@dnytst10
DNYTST10 SQL>update ny4.allinsured1 set
premium = 10
where pol_no = 15000 and SALES_ID = 174 ;
1 row updated.
DNYTST10 SQL>commit ;
Commit complete.
-- After update
DNYOIP20 SQL>select pol_no, sales_id,
premium from ny4.allinsured1 where
pol_no = 15000 ;
POL_NO SALES_ID PREMIUM
---------- ---------- ----------
15000 174 10
