title: Make HSQLDB Compatibility with DB2
body: <p>HSQL-2.3.2 is using as in-memory to test the application which is integrated DB2.</p>
  
  <p>So I am setting sql.syntax_db2=true in url as below in order to provide DB2 compatibility</p>
  
  <pre><code>jdbc:hsqldb:file:{path};shutdown=true;sql.syntax_db2=true
  </code></pre>
  
  <p>when above url using "SET DATABASE SQL SYNTAX DB2 FALSE" statement created in generated script file,but when i am passing db2,ora syntax true as below </p>
  
  <pre><code>jdbc:hsqldb:file:{path};shutdown=true;sql.syntax_db2=true;sql.syntax_ora=true
  </code></pre>
  
  <p>then both statements <code>SET DATABASE SQL SYNTAX DB2 TRUE</code> and <code>SET DATABASE SQL SYNTAX ORA TRUE</code> are created and db2 syntax is not executing  and below exception firing</p>
  
  <p>nested exception is <code>java.sql.SQLSyntaxErrorException: unexpected token: IGNORE</code></p>
  
  <p>So please share where needs to make change in order to make DB2 compatibility?</p>
  
  <p>Thanks,
  Durgesh</p>