title: SQL - How do you compare a CLOB
body: <p>in a DB2 trigger, I need to compare the value of a CLOB field.
  Something like:</p>
  
  <pre><code>IF OLD_ROW.CLOB_FIELD != UPDATED_ROW.CLOB_FIELD 
  </code></pre>
  
  <p>but "!=" does not work for comparing CLOBs.</p>
  
  <p>What is the way to compare it?</p>
  
  <p><strong>Edited to add:</strong></p>
  
  <p>My trigger needs to do some action if the Clob field was changed during an update. This is the reason I need to compare the 2 CLOBs in the trigger code.
  <strong>I'm looking for some detailed information on how this can be done</strong></p>