arrays from procedure

Posted in 2008

debadatta — Mon, 12 May 2008 13:07:21 — source: IIUG Forums & Mailing Lists

Hi I am using informix for sometime now. I am just curious whether is there any feature in informix procedures where i can pass array of records to procedure and return array of records. i do not see any documentation on this also. But is there any other way to handle to such situation. Thanks & Regards Debadatta

↪ replying to debadatta

Art Kagel — Mon, 12 May 2008 13:10:14 — source: IIUG Forums & Mailing Lists

Load the input records into a temp table that the procedure will read from. Art S. Kagel Oninit On Mon, May 12, 2008 at 9:07 AM, debadatta <mishra.dd@gmail.com> wrote: > Hi > > I am using informix for sometime now. I am just curious whether is there > any > feature in informix procedures where i can pass array of records to > procedure and return array of records. > > i do not see any documentation on this also. But is there any other way to > handle to such situation. > > Thanks & Regards > Debadatta > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

↪ replying to Art Kagel

Keith Simmons — Mon, 12 May 2008 14:48:03 — source: IIUG Forums & Mailing Lists

On 12/05/2008, Art Kagel <art.kagel@gmail.com> wrote: > Load the input records into a temp table that the procedure will read from. > > Art S. Kagel > Oninit > > On Mon, May 12, 2008 at 9:07 AM, debadatta <mishra.dd@gmail.com> wrote: > > > Hi > > > > I am using informix for sometime now. I am just curious whether is there > > any > > feature in informix procedures where i can pass array of records to > > procedure and return array of records. > > > > i do not see any documentation on this also. But is there any other way to > > handle to such situation. > > > > Thanks & Regards > > Debadatta > > > > > > > > > ******************************************************************************* > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > And using RETURN ...... WITH RESUME to output multiple records. Keith