RE: Stored Procs
Yes at least I know you can do this in a stored procedure in 9.13 (IUS) the
universal server option.
look at the documentation on RETURN WITH RESUME.
> -----Original Message-----
> From: owner-informix-list@iiug.org
> [mailto:owner-informix-list@iiug.org]On Behalf Of Patel, Parag
> Sent: Friday, September 25, 1998 9:54 AM
> To: 'informix-list@iiug.org'
> Subject: Stored Procs
>
>
> Hello:
>
> I am in the middle of evaluating INFORMIX and would like to know if it is
> possible to
> write a stored proc to return several sets of data
>
> For example:
>
> create procedure ReturnMultipleResultSets ()>
> select
> t1.column1,
> t1.column2,
> t1.column3
> from
> table_one t1,
> table_two t2
> where
> t1.column1 = t2.column1
>
> select
> t3.column1,
> t3.column2,
> t3.column3
> from
> table_three t3
>
> end procedure
>
> There a various reasons for wanting to do this which I can explain if
> necassary.
> SQL Server and Sybase, for example, provide the above.
>
> Thanks for your help.
>
> Parag Patel
>
>
>
>