cursors question
Posted in 1997
Hello,=20
a simple question about cursors in informix online 7.2
using powerbuilder as client.
If a stored procedure uses an implicit cursor such as
foreach
select ......
return.... with resume
end foreach
The client uses a corresponding loop to fetch results.
My (very simple) question is:
When the procedure is executed, how are the results handled, i.e:
are they sent to the client at once in a single operation, stored there =
somewhere, and retrieved localy by the fetch loop in the application? in =
this case, where are they stored?
are they kept on the server and returned to the client on each (client) =
fetch iteration? in this case, where are they kept?
is each iteration in the foreach executed only as the client executes a =
fetch?
Thanks in advance
Oscar Goldes