Group variable to be used as host variable in the IN stateme

hernikiten · New User Joined: 08 Apr 2005 Posts: 23 Location: india

Hi,

Can i use an array variable in a cursor like
EXEC SQL
Declare curso.......
select * from policy where policy number IN (:WS-POL-NBR)
END-EXEC

WS-POL-NBR pic 9(06) occurs 450 times.

Is it possible? what's the syntax?

dick scherrer · Posted: Tue Mar 20, 2007 10:07 pm

Hello,

I don't believe so, but you could try it out and post your result

vini_srcna · Posted: Wed Mar 21, 2007 1:28 pm

I dont think so. you may have to use some temp variable to fetch in and then pus from temp variable to the array variable. I wish i could try this one. Let us know if you have tried this.