Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- hubpayload
- SELECT hpl.rowid, hpl.* FROM hubpayload hpl
- WHERE UIDHUBPAYLOAD IN (SELECT sourcepayloadid
- FROM hubtransinstance
- WHERE transid IN ('20160112083907025783'));
- --Mette in ETC le BR della transazione
- UPDATE HUBTASKINSTANCE
- SET statuscd = 'E'
- WHERE UIDHUBTRANSINSTANCE IN (SELECT UIDHUBTRANSINSTANCE
- FROM HUBTRANSINSTANCE
- WHERE TRANSID = '20160112083907025783');
- --Apre il processo mettendolo in stato R
- UPDATE hubprocinstance
- SET statuscd = 'R' --P
- WHERE uidhubprocinstance IN
- (SELECT pi.uidhubprocinstance
- FROM hubprocinstance pi,
- hubproctransinstance pti,
- hubtransinstance ti
- WHERE pi.uidhubprocinstance = pti.uidhubprocinstance
- AND pti.uidhubtransinstance = ti.uidhubtransinstance
- AND ti.transid IN ('20160112083907025783'));
- --Risottomette la transazione
- UPDATE hubtransinstance
- SET statuscd = 'R' --C
- WHERE transid IN ('20160112083907025783');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement