title: Update table using Openquery linked server
body: <p>I've tried this code and still got the following error, perhaps anyone could help? </p>
  
  <pre><code>UPDATE a 
  SET    a.MMDWNO = '21'
  FROM   OPENQUERY(NMIIFLIB,
         'select * from MVXCDTANSN.MITMAS WHERE MMITTY = ''25''') a 
  </code></pre>
  
  <p>Error : </p>
  
  <blockquote>
    <p>OLE DB provider "MSDASQL" for linked server "NMIIFLIB" returned
    message "[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL7008 - MITMAS in
    MVXCDTANSN not valid for operation.".<br>
    Msg 7343, Level 16, State 4, Line 1<br>
    The OLE DB provider "MSDASQL" for linked server "NMIIFLIB"
    could not UPDATE table "[MSDASQL]".</p>
  </blockquote>
  
  <p>The select statement works fine but when I try to update I always stuck with this. </p>