"Serge Rielau" <srielau@ca.ibm.comwrote in message
news:6i5c4rFoto1gU1@mid.individual.net...When are we getting the execute immediate for "select ... into..." that you
mentioned about 3 years ago?

Mark A wrote:DB2 9.5 introduced dynamic SET statement. Same thing. Just better.
SET (?, ...?) = (SELECT .....)

Cheers
Serge


--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

"Serge Rielau" <srielau@ca.ibm.comwrote in message
news:6i5su7Fp0n6nU1@mid.individual.net...Just to make sure I am understanding this correctly, I need the select to be
dynamic since the table and column names change. Can the right half be a
variable?

Mark A wrote:CREATE PROCEDURE p(IN pin INTEGER, OUT pout INTEGER)
BEGIN
DECLARE txt VARCHAR(2000);
DECLARE stmt STATEMENT;
SET txt = 'SET ? = (SELECT ? + 1 FROM SYSIBM.SYSDUMMY1)';
PREPARE stmt FROM txt;
EXECUTE stmt INTO pout USING pin;
END
@

db2 =call p(6, ?)@

Value of output parameters
--------------------------
Parameter Name : POUT
Parameter Value : 7

Return Status = 0


--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Justin,

Where did you find that syntax? And double quotes for a string?
You need to declare the cursor on a STATEMENT type variable'-statement-name---' <-- You are here


So you do:

DECLARE txt VARCHAR(1000);
DECLARE stmt STATEMENT;
DECLARE cur CURSOR WITH RETURN TO CLIENT FOR stmt;

SET txt = 'SELECT ....';
PREPARE stmt FROM txt;
OPEN cur;


--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Serge,

I am impressed with your quick response. The double quotes / syntax
were attempts on my part to try various options.

But - the last suggestion worked.

Thank you very much.

-JB



On Sep 4, 10:20 am, Serge Rielau <srie...@ca.ibm.comwrote: