Subject | Fetch rows one by one |
---|---|
Author | Aurimas Černius |
Post date | 2009-05-28T07:11:37Z |
Hello,
I have a procedure, which does a long lasting updates (about 1 hour
total). In order to see the progress, procedure suspends rows between
separate update statements.
AFAIK, if I don't use any "order by", just a dummy "select * from proc",
I should be able to get get first few rows before the completion of
procedure execution.
How can I do this with IBO? It seems, that it fetches a certain about of
records, so I need to wait until procedure suspends them. How can I
fetch records one at a time?
--
Aurimas
I have a procedure, which does a long lasting updates (about 1 hour
total). In order to see the progress, procedure suspends rows between
separate update statements.
AFAIK, if I don't use any "order by", just a dummy "select * from proc",
I should be able to get get first few rows before the completion of
procedure execution.
How can I do this with IBO? It seems, that it fetches a certain about of
records, so I need to wait until procedure suspends them. How can I
fetch records one at a time?
--
Aurimas