Re: still need help
Posted in 1998
Topics: Stored Procedures & SPL
This is a multi-part message in MIME format.
--------------04DCBC51D7178C728F2DC22D
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Hi,
Your should to create a table for each statement Select and to return
their names.
Bye
aurelio wrote:
> How can I return a large list of attributes retrieved with different
> SELECT's?
> I use Dymanic Server 7.3.
> Maybe it could be with row types, but they are not supported by Dynamic
> Server 7.3
>
> create procedure p1(some parameters)> returnung ?...
> select a,b,c from table1 where...; The procedure/function migth> return a,b,c,e,f,g
> select e,f,g from table2 where...; And maybe no rows are> retrieved in second SELECT, so I don't need to return values e,f,g.
> ...
> end procedure;
--------------04DCBC51D7178C728F2DC22D
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Enrique Lopez
Content-Disposition: attachment; filename="vcard.vcf"
begin: vcard
fn: Enrique Lopez
n: Lopez;Enrique
org: CTI
email;internet: informix@uco.es
x-mozilla-cpt: ;0
x-mozilla-html: TRUE
version: 2.1
end: vcard
--------------04DCBC51D7178C728F2DC22D--