title: Running Common Table expression in netezza as a script with Update at the end of CTE
body: <p>I am trying to run a CTE in script form </p>
  
  <p>e.g</p>
  
  <pre><code>with CTE as 
  (select * from sometable);
  </code></pre>
  
  <p>on running this code part alone in the I am getting the error</p>
  
  <blockquote>
    <p>^ found "" (at char 152) expecting <code>SELECT' or</code>'('' */</p>
  </blockquote>
  
  <p>Please let me know how to run this query. thanks</p>