I have been trying to use DB2 array with dynamic SQL,

set sql_str = 'select * from emp e, UNNEST(array_var) as aa(id) where e.id = aa.id';

any help on the would be much appreciated.

Thanks
Kumar