SQL in rpg

Can anybody help
I have a display file with up to 12 selection fields, all are optional, and
would like to build a
subfile based on the the results of an SQL selection. I believe that it is
possible with a
dynamic SQL selection but have been unable to get past the pre-compiler
error message 
SQL 0312. could anybody please provide me with an example in RPG (Not ILE).
Any help would be greatly appreciated.

_________________________________________________ 
Regards 
Chris Baker 
Telephone : 02476 852625 
email        :  <mailto:chrisbaker@xxxxxxxxxxxx> chrisbaker@xxxxxxxxxxxxxxx 

 


*********************************************************************************
This email is intended solely for the use of the individual to whom
it is addressed and may contain confidential and/or privileged 
material.  Any views or opinions presented are solely those of the 
author and do not necessarily represent those of AGCO.
If you are not the intended recipient, be advised that you have
received this email in error and that any use, dissemination, 
forwarding, printing or copying of this email is strictly prohibited.
 
Neither AGCO nor the sender accepts any responsibility for viruses and it is 
your
responsibility to scan and virus check the e-mail and its attachment(s) (if 
any).
*********************************************************************************