I have a SP, that does some tasks, which take some time to execute. So I
thought, I change the SP to a selectable SP and do a 'suspend' between
every task. The client, who executes the SP, can then add another step
in a ProgressBar for example. Here's a pseudocode version of the SP:

CREATE PROCEDURE P_SELECT_TEST
RETURNS (
ACTIONTYPE INTEGER)
AS
begin
Do Task 1;
Actiontype=10;
suspend;

Do Task 2;
Actiontype=20;
suspend;

Do Task 3;
Actiontype=30;
suspend;

Do Task 4;
Actiontype=40;
suspend;
end

The client runs:
select ActionType from P_SELECT_TEST

and when a row is fetched from the server, I add a step to a
progressbar. Now I have detected, that the server executes the whole SP
to the end and then sends the first row to the client. That's exactly
why I don't want. Exists a way achieve, that the server starts the SP
and send a row to the client after every 'suspend'?

Regards

Guido