"AMOUNT1" is not valid in the context where it is used
<p>I'm executing the the following query in DB2:</p>

<pre><code>select  
  SUM (orders.totalproduct
      +orders.TOTALTAX
      +orders.totalshipping
      -orders.totaladjustment) as amount1 
from 
  orders  
where 
  amount1&gt;10000
</code></pre>

<p>The query is not executed, I get this exception instead:</p>

<blockquote>
  <p>"AMOUNT1" is not valid in the context where it is used.. SQLCODE=-206, SQLSTATE=42703, DRIVER=3.64.96 SQL Code: -206, SQL State: 42703</p>
</blockquote>

<p>What am I doing wrong?</p>