Hi ,

I have to write a stored procedure which would accept an array as an input parameter. But since there is no Array datatype available in db2 till Ver 9.5, is there any workaround that i can use ??? How would i be able to take in the parameters and run a loop like in C using a DB2 stored proc ....??? Is it possible at all ?? If so an example of how to do it would be fantastic ..


Any help in this regard is deeply appreciated ...


Thanks,
Libin.

Your only alternative is to store the values in a table or temp table and have the SP fetch the values in your loop.

Andy