title: Simple informix select stored procedure
body: <p>I am trying to write a simple stored procedure that does a select statement but it keeps giving me a syntax error without any other help telling me what the error is</p>
  
  <pre><code>create procedure _this_is_it(this CHAR(3), that CHAR(4), other CHAR(3))
  foreach select * from table 
  where column1 = this and
  column2 = that and
  column3 = other
  end foreach
  end procedure;
  </code></pre>
  
  <p>Any reason why I should get a syntax error?</p>