title: DB2 SQL instead of update trigger
body: <p>Hi I have the following code, for create a DB2 SQL trigger, extended</p>
  
  <pre><code>connect to sample
  @
  
  drop TABLE countries
  @
  drop view view1
  @
  drop TRIGGER update_view1_2
  @
  
  CREATE TABLE countries (id int, country varchar(50), region varchar (50), average_temp int)
  @
  CREATE VIEW view1 (id, continent, temperature) as SELECT id, region, average_temp from countries
  @
  
  CREATE TRIGGER update_view1_2
  INSTEAD OF UPDATE ON view1
  REFERENCING OLD AS o NEW AS n
  FOR EACH ROW
  MODE DB2SQL
  BEGIN ATOMIC
      UPDATE countries c
      SET c.region = n.continent
      WHERE c.region = o.continent;
  END
  @
  </code></pre>
  
  <p>I run this script with this:
  <code>db2 -td@ -v -f trig_ipd_wiev1.db2 -z procs.log</code></p>
  
  <p>----PROBLEM SOLVED----</p>