Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2006

    Unanswered: How to make Informix Stored Procedure Able To Return Multiple Rows of Data

    HI, i am a new bee in Informix Sql.
    I have search online but no resource on how to return multiple rows of data from stored procedure.

    For sql server 2005,
    i just need to select whatever data i want to return...

    but it is not same in Informix...
    Does anyone has any idea on returning multiple rows of data from a stored procedure?
    Help Please !!

  2. #2
    Join Date
    Sep 2010
    Germany, Brunswick
    create procedure test () returning int, char(50);
      define a int;
      define b char(15); 
      foreach c1 for
        select customer_num, lname into a,b from customer
        return a, b with resume;
      end foreach;
    end procedure;
    select a, b
    from table(test())(a,b)
    where a > 110;
    Return values from an SPL function

  3. #3
    Join Date
    Dec 2006
    Got It!!
    Thanks InformixWilli !!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts