Advertisement
Guest User

Untitled

a guest
Feb 9th, 2016
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.16 KB | None | 0 0
  1. -- hubpayload
  2. SELECT hpl.rowid, hpl.* FROM hubpayload hpl
  3. WHERE UIDHUBPAYLOAD IN (SELECT sourcepayloadid
  4. FROM hubtransinstance
  5. WHERE transid IN ('20160112083907025783'));
  6.  
  7. --Mette in ETC le BR della transazione
  8. UPDATE HUBTASKINSTANCE
  9.    SET statuscd = 'E'
  10.  WHERE UIDHUBTRANSINSTANCE IN (SELECT UIDHUBTRANSINSTANCE
  11.                                  FROM HUBTRANSINSTANCE
  12.                                 WHERE TRANSID = '20160112083907025783');
  13.  
  14.  
  15. --Apre il processo mettendolo in stato R
  16. UPDATE hubprocinstance
  17.    SET statuscd = 'R'                                                      --P
  18.  WHERE uidhubprocinstance IN
  19.           (SELECT pi.uidhubprocinstance
  20.              FROM hubprocinstance pi,
  21.                   hubproctransinstance pti,
  22.                   hubtransinstance ti
  23.             WHERE     pi.uidhubprocinstance = pti.uidhubprocinstance
  24.                   AND pti.uidhubtransinstance = ti.uidhubtransinstance
  25.                   AND ti.transid IN ('20160112083907025783'));
  26.  
  27.  
  28. --Risottomette la transazione
  29. UPDATE hubtransinstance
  30.    SET statuscd = 'R'                                                      --C
  31.  WHERE transid IN ('20160112083907025783');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement