Re: is correct to use RCPFUNC with Informix ?

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