title: Prepared Statement failing with DB2 SQL error: SQLCODE: -401, SQLSTATE: 42818
body: <p>I am working on an application which updates data in a database(IBM DB2 v 9.7) via JDBC . Here's The table schema:</p>
  
  <p>Column name    Data Type      Length</p>
  
  <p>1)INDEX                   BIGINT          -</p>
  
  <p>2)USER_NAME      VARCHAR     30</p>
  
  <p>3)SRC                      VARCHAR     30</p>
  
  <p>4)STATUS                VARCHAR     150</p>
  
  <p>5)RT_COUNT         BIGINT           -</p>
  
  <p>And my Code is as:</p>
  
  <pre><code>                                      String cmd1="Update ANALYTICS  SET RT_COUNT = 1 WHERE USER_NAME = ? AND STATUS = ?";
                                       PreparedStatement process=connection.prepareStatement(cmd1);
  
                   process.setString(1, Source);
                   process.setString(2, Content);
  
  
                   if(process.executeUpdate()==0)
                   {....
  </code></pre>
  
  <p>But it fails,can anyone help me ?</p>
  
  <p>Thanks and regards</p>