Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
mql unsign bus? question?
- Thread starter badrion
- Start date
johnlopez2000
Programmer
You can do both in MQL.
Do an "mql override ..." to go past the signature. Then do an "mql promote bus ..." to affect the state transition.
This will show in Matrix history that the signature was not signed, but that it was over ridden.
Also, you may want to control your transaction boundries in Oracle by wrapping the above with "start trans" at the beginning and "commit trans" at the end. Therefore, if some portion of the above fails, then the whole thing will roll back in the database.
Finally, I'd recomend using the 'catch' statement:
set x [catch
{mql override bus ...;
mql promote bus ...} errmsg]
this is good for 2 things. First all must complete successfully, and second this is an alternate method of controlling the transaction boundries. If any statement in the 'catch' fails, the transaction will roll back.
Do an "mql override ..." to go past the signature. Then do an "mql promote bus ..." to affect the state transition.
This will show in Matrix history that the signature was not signed, but that it was over ridden.
Also, you may want to control your transaction boundries in Oracle by wrapping the above with "start trans" at the beginning and "commit trans" at the end. Therefore, if some portion of the above fails, then the whole thing will roll back in the database.
Finally, I'd recomend using the 'catch' statement:
set x [catch
{mql override bus ...;
mql promote bus ...} errmsg]
this is good for 2 things. First all must complete successfully, and second this is an alternate method of controlling the transaction boundries. If any statement in the 'catch' fails, the transaction will roll back.
- Status