07-15-10, 18:04 #1Registered User
- Join Date
- Jul 2010
Unanswered: Using DB2 Arrays with Dynamic SQL
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.