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 ?
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 100000CHVU401 Posts
Re: how to implement array in SPL2012-04-16T07:59:31ZThis is the accepted answer. This is the accepted answer.Hi 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.