title: db2 equivalent of tsql temp table
body: <p>How would I do the following TSQL query in DB2?  I'm having problems creating a temp table based on the results from a query.</p>
  
  <pre><code>SELECT 
  COLUMN_1, COLUMN_2, COLUMN_3
  INTO #TEMP_A
  FROM TABLE_A
  WHERE COLUMN_1 = 1 AND COLUMN_2 = 2
  </code></pre>
  
  <p>The error message is:</p>
  
  <blockquote>
    <p>"Error: SQL0104N An unexpected token "#TEMP_A" was found following "". Expected tokens may include: ":". SQLSTATE=42601"</p>
  </blockquote>