title: IBM DB2 Select named column, then select *
body: <p>I can't seem to figure out how to do the following in an IBM DB2 select statement:</p>
  
  <pre><code>SELECT column1, *
  FROM [some table]
  </code></pre>
  
  <p>I get the following error:</p>
  
  <pre><code>SELECT ACCT_NUM, * FROM GEG1.RENL_RATING_STRUC
  SQL0104N  An unexpected token "*" was found following "".  Expected tokens may include:  "+ - ROW NEXTVAL PREVVAL NEXT PREVIOUS ( &lt;INTEGER&gt; &lt;DECIMAL&gt;".  SQLSTATE=42601
  </code></pre>
  
  <p>I searched for a syntax document, but I couldn't find one. Can anyone help with this?</p>