title: DB2 Automatic Initialization and Updating for TIMESTAMP
body: <p>I would like to append two timestamp columns to an existing table. 
  CREATED_TSTMP would be populated with the current timestamp when a record is inserted and LAST_UPD_TSTMP would be updated automatically when a record in the table gets updated. </p>
  
  <p><strong>I would like to do this without having to modify existing queries.</strong></p>
  
  <p>I have the following DDL statements:</p>
  
  <pre><code>ALTER TABLE XXX ADD CREATED_TSTMP TIMESTAMP NOT NULL WITH DEFAULT CURRENT TIMESTAMP ;
  alter table XXX add column LAST_UPD_TSTMP timestamp not null generated by default for each row on update as row change timestamp ;
  </code></pre>
  
  <p>However once the columns are appended, this will cause an existing query with the following syntax:</p>
  
  <pre><code>INSERT INTO XXX VALUES(?,?,?,?,?,?,?,?,?,?)
  </code></pre>
  
  <p>to fail with </p>
  
  <blockquote>
    <p>The number of values assigned is not the same as the number of
    specified or implied columns or variables..</p>
  </blockquote>
  
  <p>Is there any way around this problem without having to inspect all of the existing queries (there are hundreds of them...) </p>