title: how to resolve 'Update operation attempted on non-updatable query'?
body: <p>I am working on a sybase-iq server <code>Sybase IQ/15.4.0.3014</code></p>
  
  <p>I have a working query to update one field of a table as below</p>
  
  <pre><code>update  table1
  set     a.field1= b.some_value
  from    table1 a,
          table2 b
  where   a.id = b.id
  </code></pre>
  
  <p>This is working fine when I execute it from a sql session. When it is being called from a high level application, I am getting the below error for the above query</p>
  
  <blockquote>
    <p>SQL Exception code is 7301<br>
    Update operation attempted on non-updatable query</p>
  </blockquote>
  
  <p>I am not able to find why I am getting this error. Is there any solution to amend the query. Searching on the internet is not helping much.</p>
  
  <p>Have anyone come across such issue?</p>