Hello,helen:

>you wrote:

>If you *want* to get multiple rows back, use a FOR SELECT...INTO
><variables> DO....SUSPEND and submit your request using a SELECT ... FROM
>procedurename (parameter_list) statement instead of EXECUTE PROCEDURE
>procedurename (parameter_list).

You mean that 'EXECUTE PROCEDURE procedurename (parameter_list).' is not a good way?
If the procedure hasn't return value,how use the syntax 'SELECT ... FROM procedurename (parameter_list)'?

TIA

Best Regard.

jinyang