June 30, 2010, 05:04 AM
swell.wangHELP~~!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.
July 09, 2010, 11:49 AM
KerryHi 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