Re: Executing Stored procedures with multiple Result sets

Mike Gallagher wrote: > > Are there any limitations in ODBC with respect to executing stored > procedures. I am currently using Sybase/db-lib and I routinely execute > stored procs that return multiple (different) result sets. I know > Informix is limited to one result set per stored procedure. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Whoa there, Mike! Please explain what you mean by a "result set". A stored procedure (in Informix) can return many rows of data and each row can consist of many columns. It does this by declaring its own cursor, FOREACH loop and the statement "RETURN... WITH RESUME". Next time the procedure is called, it starts executing from the statement following that RETURN. Is this the capability you are looking for? -- -- Jake (In pursuit of undomesticated aquatic avians) +-----------------------------------------------------------+ | Impeccable Logic: A thought process which successfully | | resists chicken bites | +-----------------------------------------------------------+