title: Insert Blank value in DB2 for different data types
body: <p>I have a table in DB2 with more than 150 columns of different data types including CHARACTER, DECIMAL, DATE, TIMESTAMP and VARCHAR.</p>
  
  <p>I am creating an insert script for only one record where I need the first column to be populated by a default value and all remaining columns should be Blank irrespective of the data type.</p>
  
  <p>For e.g.</p>
  
  <pre><code>INSERT INTO TABLE1 (COL1, COL2, COL3, COL4 ... COL150)
  VALUES ('hello','','','','' ... '')
  </code></pre>
  
  <p>COL1 is CHARACTER, COL2 can be TIMESTAMP, COL3 can be VARCHAR, COL4 can be VARCHAR. Can I use '' for all data types?</p>