Billy Wheeler wrote:
>
> On 19 Oct 97 at 17:39, Philippe Verdy wrote:
>
> > Informix, as opposed to Sybase, does not allow a stored procedure to
> > return multiple results sets.
>
> No comment on the rest of the post, but this is definitely incorrect.
No Billy, Philippe is correct, he is not saying that Informix SPL cannot
return multiple records but that it can only return one set of values
which is consistent from record to record. Sybase with their Cheech and
Chong attitude ("Standards? We don't need no stinking standards!") can
return different values/types/numbers of values from one returned record
to the next (ie first call returns column labels, all text, next few
calls return data, then return totals for only some columns on last
call). For this reason you cannot DESCRIBE a call to a Sybase Stored
Procedure so PB scans the source code to guess the returns and their
sequence.
Art S. Kagel