Fetch value from Dynamic SQL

[dnivraramuk]

Hi,
I want to fetch a values from a dynamic SQL, but don't know what would be the syntax and way to do it..
I have the synamis SQL as :

SET V_SQL_STMT ='SELECT CHAR('|| V_ELEMENT_NAME ||
') FROM ODS.'||V_TABLE_NAME||' WHERE '|| V_JOIN_COLUMN1||' = ? ';

PREPARE s1 FROM V_SQL_STMT ;

EXECUTE s1 USING V_KEY1;

Here I want to fetch the output of my select statement into a variable in a store procedure.
I am using DB2 UDB 7.2.6. Help is highly appritiate.
Thanks,
Arvind

 

[esskayind]

Hi,
You can declare a cursor for the select statement,open it , fetch into a variable and close the cursor.
I think, It helps you.
Thanks,
Thangam

 

[MarcLodge]

If you still require help, try this link:

http://www-3.ibm.com/software/data/db2/udb/ad/v7/adg/db2a0/frame3.htm#dynamic

 

[dnivraramuk]

I tried working out as You said, but could not succeed..


SET V_SQL_STMT ='SELECT CHAR('|| V_ELEMENT_NAME ||
') FROM ODS.'||V_TABLE_NAME||' WHERE '|| V_JOIN_COLUMN1||' = ? ';

PREPARE s1 FROM V_SQL_STMT;
DECLARE c1 CURSOR FOR s1;
OPEN c1 using V_KEY1;
FETCH c1 into V_VALUE;

Tell me if I am missing out something...

regards,
Arvind