Re: SQL, SPL question

>From: jcs@travelsurf.com >Date: Sat, 11 Jan 1997 09:08:18 -0700 >X-Informix-List-Id: <list.12606> > >Can I do the following : > > declare a SPL, say test_spl(), which return more than 1 value. > > in my select statment, > > SELECT test_spl() ... > > I try this, but the database complain about the spl returns too many > values. how can I take care of this problem? Thanks. You have two choices: 1. Only use the test_spl() procedure in EXECUTE PROCEDURE statements, 2. Do not use RETURN...WITH RESUME in the stored procedure or try to return multiple values in a single return statement. This information is not in the 7.2 manuals (or earlier versions), but should be in the next edition. This was discussed at some stage in later 1996, and the Documentation team at Informix was notified of the omission. Depending on your language, you may need to use a cursor for the EXECUTE PROCEDURE statement to get back all the rows. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>