HI,
I MET ONE strange thing.
before i insert data into Table T , i should set one filed of T to 0.
so ,I create a stored procedure A,like this:

SQL SQLORA SET DEFAULT_CONNECTION report
SQL SQLORA
UPDATE EDW_RBASIS.OMS_SALE_ORDER_KL K
SET K.ARRIVE_QTY = 0 WHERE K.CIRCLE_YEAR=2010 AND K.CIRCLE_WEEK=26
;
COMMIT;
END
-RUN

then new a DBMS Sql flow B to do the update/insert operation.
then new a a flow C include A & B,
BUT WHEN Flow C is running,it looks B is running without be finishied...



how does this question happen? what should i do to fix it?

any reply is appreciated.

Hi Swell,

Suggestion from our iWay technicals: to better understand the issue, we will need to see the flows and synonyms. So it is better that you open a case with Information Builders' Customer Support Services for assistance. The phone number is 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry