Results 1 to 2 of 2

Thread: Separator

  1. #1
    Join Date
    Dec 2011

    Red face Unanswered: Separator

    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.

  2. #2
    Join Date
    Jan 2007
    Jena, Germany
    You can have a look here how to write such a function: Parsing Strings in SQL
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts