Re: is correct to use RCPFUNC with Informix ?

On 21 Oct 97 at 12:35, Art S. Kagel wrote: } 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. I stand corrected. I misunderstood. But this is hilarious. It must be one of those things that make Sybase "better" than Informix... I must just be dumb or something, but this sounds like more trouble than it's worth. Of course, I fully expect 200 posts proving me wrong...:-) -- Ciao, Billy Nose to the ear in Johannesburg -- Murder City never looked so good! Get the Informix FAQs of life at http://www.iiug.org/techinfo/faq/faq_top.html Need to get some drivel into your life? http://www.west.co.za/tasteless/