title: Error 360: Cannot modify table or view used in subquery
body: <p>INFORMIX-SE 7.32:</p>
  
  <p>I'm getting error 360 when I try to execute the following statement:</p>
  
  <pre><code>update transaction
     set transaction.colx = (select tab1.cola from tab1)
   where transaction.num  = (select max(transaction.num) from transaction)
     and transaction.colx IS NULL;
  </code></pre>
  
  <p>Any ideas?</p>