As you might have noticed the difference between the two SQL clauses.
select col from tab where item in ("item1", "item2")
select col from tab where item in ("item1,item2")
It seems that there's no equivalent in DB2 to string_split function as in SQL Server.
Hope someone else familiar with DB2 could provide a solution.
Or simply create 8 parameters, simple but troublesome