title: DB2 SQL Error: SQLCODE=-421, SQLSTATE=42826, SQLERRMC=null
body: <p>I've never used DB2 before. there is a strange error.when I use jdbc to execute the following sql :</p>
  
  <pre><code>select id,name,description,sysflag from t_perm_template where sysflag=1
  union all
  select id,name,description,sysflag from t_perm_template where sysflag =2
  </code></pre>
  
  <blockquote>
    <p>return error :DB2 SQL Error: SQLCODE=-421, SQLSTATE=42826,
    SQLERRMC=null....</p>
  </blockquote>
  
  <p>but the sql could execute corretly in IBM Data Studio.</p>
  
  <p>I searched on the ibm,42826-The rows of UNION, INTERSECT, EXCEPT, or VALUES do not have the same number of columns.but apparently,columns are the same.</p>
  
  <p>why?</p>