Topic
  • 3 replies
  • Latest Post - ‏2012-04-16T10:06:05Z by SystemAdmin
SystemAdmin
SystemAdmin
1143 Posts

Pinned topic how to implement array in SPL

‏2012-04-13T11:33:27Z |
Hi Experts,

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 ?

Thanks,
Saumya
Updated on 2012-04-16T10:06:05Z at 2012-04-16T10:06:05Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    1143 Posts

    Re: how to implement array in SPL

    ‏2012-04-16T06:58:30Z  
    Hi Experts ,

    Any comment on this ?

    Thanks,
    Saumya
  • andreasl
    andreasl
    372 Posts

    Re: how to implement array in SPL

    ‏2012-04-16T07:59:31Z  
    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.

    HTH,
    Andreas
  • SystemAdmin
    SystemAdmin
    1143 Posts

    Re: how to implement array in SPL

    ‏2012-04-16T10:06:05Z  
    Hi Experts ,

    Any comment on this ?

    Thanks,
    Saumya
    Thanks :-). Using TEMP table now in my SP.