Re: Why this Stores Procedure is not working - puzzled
by Serge Rielau <srielau@[EMAIL PROTECTED]
>
Jul 17, 2008 at 09:45 PM
db2 => ? SQL0084;
SQL0084N An EXECUTE IMMEDIATE statement contains a SELECT or VALUES
statement.
Explanation:
A SELECT or VALUES statement was used in an EXECUTE IMMEDIATE statement.
The statement cannot be processed.
User response:
The implied function is not sup****ted. Prepare the SELECT or VALUES
statement. Then use OPEN, FETCH, and CLOSE.
sqlcode: -84
sqlstate: 42612
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
