title: Mass replace Null values in DB2 simple way
body: <p>We have different tables which have been accidentially filled in various fields with null values which are now causing problems when trying to display them.</p>
  
  <p>I know how I could replace them one column by one, but I would like to know if there is <strong>an easy way</strong> to replace all null values in all columns. I did not come up with any possible solution.</p>
  
  <p>Calculating 30 tables with about 80 columns in average this would take a while creating the SQL(s).</p>
  
  <p><strong>Any suggestions how to simplify this task?</strong>
  We use DB2 V9, in case there is a function for it or similar</p>
  
  <p>Thanks in advance</p>
  
  <p>Xavjer</p>