Re: Stored Procs
In article <6ug8ji$b5n$1@news.xmission.com>,
PatelP@Exchange.AtlantaGA.NCR.com (Patel, Parag) wrote:
>
> 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
return col1, col2, col3 with resume
>
> select
> t3.column1,
> t3.column2,
> t3.column3
> from
> table_three t3
>
return col1, col2, col3 with resume
> 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
>
>
>
>
Paul Watson # I don't suffer from
WF Software Ltd. # stress, I'm just
Tel. (+44) 1436 674729 # a carrier
Fax. (+44) 1436 678693 #
www.wfsoftware.co.uk