title: Why does a "WITH" clause give a syntax error on Informix?
body: <p>I am trying a query similar to the below one on Informix, but I get a syntax error (-201: "A syntax error has occurred") every time. </p>
  
  <pre><code>with a_qry (locationnames) as (SELECT * FROM TABLE(LIST{'abc','xyz'}))
  select locationnames from a_qry;
  </code></pre>
  
  <p>Can someone please help with this?</p>