is there any inbuilt function of separating in db2 8.2.
as ARRAY TYPE is not working with db2 8.2.
so i will pass array of string separated by comma(,) n that function will identifies comma(,) and split that word..
no length is fix for data..
for eg..
i will pass this list n some function will separate it.
i want to separate (queen,king,joker,db2,dbadmin,hello,welcome)...

thank you.

You can have a look here how to write such a function: Parsing Strings in SQL