tuarek wrote:
> Serge,
>
> Please correct me if I'm wrong.
>
> To invoke a SP, we have to issue a "CALL" . Even if the SP returns a
> result set, we wouldn't be able to use its output in a SQL statement
> because "CALL" cannot be implicity issued from a sql statement.
Correct. If the procedure is "given" then you will need to process the
result set row by row using row inserts.

Cheers
Serge


--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab