title: db2 insert failure when ' present (even escaping doesn't work)
body: <p>I am running an insert command on db2 like the following:</p>
  
  <pre><code>insert into uinfo.transaction (TRANSACTION_ID, DATE,TIME,ID,USER,DESC) values
  (14,20110311,36909,97,2497580,'Note:9045-02 2=34 ///' 2eq034d,xw d""::: 214l 23e;l2')
  </code></pre>
  
  <p>It gave an error saying, During SQL processing it returned: </p>
  
  <pre><code>SQL0103N The numeric literal "2034d" is not valid. SQLSTATE=42604
  </code></pre>
  
  <p>So, I tried escaping the <code>'</code> as following: </p>
  
  <pre><code>insert into uinfo.transaction (TRANSACTION_ID, DATE,TIME,ID,USER,DESC) values
  (14,20110311,36909,97,2497580,'Note:9045-02 2=34 ///\' 2eq034d,xw d""::: 214l 23e;l2')
  </code></pre>
  
  <p>It still fails saying the same thing. During SQL processing it returned:</p>
  
  <pre><code>SQL0103N The numeric literal "2034d" is not valid. SQLSTATE=42604
  </code></pre>
  
  <p>Any idea what is wrong above and can I overcome this?</p>