Subject Re: for select do - statement in nested SP
Author Ulrich
Luc,

>
> That's not quite true.
> Every procedure can return values without suspend.
> Suspend is for returning MULTIPLE values (records).
>
> Suspend is used for procedures that are selected from, without
> suspend
> you have to execute the procedure and return one set of return
> parameters.
>
> Luc.

Ok, your explanation is far more precise. My basic mistake was, to
think that the SUSPEND statement is nessesary to loop through the
selected records. That's totally wrong.

It's needed to give back multiple records.

> SUSPEND is not for cvatching the record, it is for writing it to
> the output stream.

That's the point, I didn't understand!


Thanks - Ulrich