Hi all,

I am trying to pass varchar as input parameter in my stored procedure. This varchar has comma separated values. For e.g.

name is my varchar input parameter having values -
'name1, name2, name3, name4, name5'

I want to split these values in stored procedure and to retrieve these values in an array. I am using db2 8.2. How to do it?
As per my knowledge I can't create user-defined array type in db2 8.2. So I am trying to take all values as comma separated in single varchar variable and as input parameter, passing through the stored procedure. Now I want this splitted values in simple varchar array. Please provide me some solution over this.

I really appreciate your help.

I won't even bother explaining that this is an FAQ and a little bit of search would turn up, for example: Parsing Strings in SQL