Dynamic SQL

["Mike Pantzopoulos - \(H/O\)" <mpantzopoulos@xxxxxxxxxxxxxxxx>]

I want to be able to issue an SQL request via CL after formatting the
SQL depending on parameters passed in. I have heard that there is an API
which allows this but the only one I can find is
'QxdaProcessImmediateEDRS'. 

I'm a newbie with APIs and I can't work out if I have the right API and
if I do how do I call it because of the length of the API name.

Or is there an even simpler way? Without resorting to RUNSQLSTM with
dynamic updates to the source file.

Thank You. 

Mike Pantzopoulos
EIG-Ansvar Limited
Tel  : 61 (3) 9614 3535
Fax: 61 (3) 9614 2740



*********************************************************************************************************
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient, any use, disclosure or copying of this message is unauthorised. If you have received this message in error, please reply using the sender's email address. 

This footnote confirms that this email message has been scanned for computer viruses. EIG-Ansvar Limited does not accept liability for any loss or damage, whether caused by our own negligence or not, that results from a computer virus or defect in the transmission of this email or any attached file. 
EIG-Ansvar Limited - Australia (A.B.N. 21 007 216 506)
Email : insure@xxxxxxxxxxxxxxxx

Eig-Ansvar Limited - New Zealand
Email : insure@xxxxxxxxxxxxxxxx

*********************************************************************************************************