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
UPDATE EDW_RBASIS.OMS_SALE_ORDER_KL K
SET K.ARRIVE_QTY = 0 WHERE K.CIRCLE_YEAR=2010 AND K.CIRCLE_WEEK=26
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.
windows xp sp3
excel,html ,pdf,and graph
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.
Focal Point Moderator
Information Builders, Inc.
|Powered by Social Strata|