Hi,

How to pass a list to a static sql ?

again is it possible ?

if not, what is the solution ?

thks. in adv.

Your question is rather ambiguous. Can you be more specific or supply some example of what you want to accomplish? Also supply the DB2 version and OS you are using.

Andy

If you mean with "list" that you have multiple host variables and you may not know how many (very different meaning from the usual usage of that term), then the answer is "yes". You can set up an SQLDA with as many SQLVAR members as you need, set up each SQLVAR and then execute the static or dynamic embedded SQL statement with that SQLDA.

I think he means pass an array to a stored procedure, which you can do in Oracle, but not in DB2.

Great: three readers, three different ideas what may have been meant. ;-)