still need help
Posted in 1998
aurelio — — source: Informix-list mailing list archive (1991-1998)
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 migthreturn a,b,c,e,f,g
select e,f,g from table2 where...; And maybe no rows areretrieved in second SELECT, so I don't need to return values e,f,g.
...
end procedure;