title: ON COMMIT PRESERVE ROW not working
body: <p>I want to load a data in temp table in DB2. in syntax when i use ON COMMIT PRESERVE ROWS compiler throws an error: </p>
  
  <blockquote>
    <p>Lookup Error - DB2 Database Error: ERROR [42601] [IBM][DB2/AIX64] SQL0104N  An unexpected token "ON" was found following "P BY ACCOUNT_NUMBER)".  Expected tokens may include:  "".</p>
  </blockquote>
  
  <p>When I replaced On commit preserve rows by <strong>definition only</strong> temp table is successfully created but I don't see my sub query data inserted in the temp table. Can you please help me where I am making mistake?</p>
  
  <pre><code>DECLARE GLOBAL TEMPORARY TABLE SESSION.TEMP_TABLE AS 
  (SELECT ACCOUNT_NUMBER, NET_AMOUNT
  FROM SCHEMA.TABLE_NAME WHERE 1=1 AND COLUMN1='a') ON COMMIT PRESERVE ROWS; 
  </code></pre>