Array in informix???

Posted in 2010

CARLOS LINO — Wed, 22 Sep 2010 12:18:44 — source: IIUG Forums & Mailing Lists

HI: I WOULD LIKE TO KNOW IF IT CAN USE ARRAYS IN A SPL. IF THAT TRUE? PLEASE SHOW ME AN EXAMPLE PLEASE..!! REGARDS....

↪ replying to CARLOS LINO

Art Kagel — Wed, 22 Sep 2010 16:46:31 — source: IIUG Forums & Mailing Lists

No arrays, but there are temp tables. If you create a temp table with a SERIAL column as index, you can treat it like an array, or you can then load the table contents into a ROW typed MULTISET and use that as an in-memory array. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Sep 22, 2010 at 8:18 AM, CARLOS LINO <carlos_lv8@hotmail.com> wrote: > HI: > > I WOULD LIKE TO KNOW IF IT CAN USE ARRAYS IN A SPL. IF THAT TRUE? PLEASE > SHOW > ME AN EXAMPLE PLEASE..!! > > REGARDS.... > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --00163630f2971b3bbf0490dbe397