I'm anxious to learn how to implement arrays in SPL in informix.I want to store a set for values retreived from SELECT in an array and take some actions based on the data .Strangely even after googling for hrs in search of implementing arrays I didn't find anything. Can anybody help me on this ?
This topic has been locked.
3 replies Latest Post - 2012-04-16T10:06:05Z by SystemAdmin
Pinned topic how to implement array in SPL
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-04-16T10:06:05Z at 2012-04-16T10:06:05Z by SystemAdmin
andreasl 100000CHVU331 PostsACCEPTED ANSWER
Re: how to implement array in SPL2012-04-16T07:59:31Z in response to SystemAdminHi Saumya,
there's no such thing as arrays in SPL afaik.
The mechanism getting closest to arrays might be a scroll cursor, in combination with a temp table in case locking of the original rows should be avoided. You can position in a scroll cursor similarly to accessing an array's elements.