Focal Point
HELP~~!I COULD NOT INSERT DATA AFTER UPDATE ORPERATION

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/506105774

June 30, 2010, 05:04 AM
swell.wang
HELP~~!I COULD NOT INSERT DATA AFTER UPDATE ORPERATION
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.


webfocus 7.65
windows xp sp3
excel,html ,pdf,and graph
July 09, 2010, 11:49 AM
Kerry
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


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.