Support Questions

Find answers, ask questions, and share your expertise

Run Multiple Update Statements Transitionally

avatar
Contributor

I have a scenario where I need to set the status column in two tables to 'C' to mark the request as completed. 
Currently I am doing it using two PutSQL processors but I want to do that in a Transactinoal way to keep both tables consistent. 

UPDATE REQUEST SET STAT_CD = 'C', UPDT_DT= CURRENT_TIMESTAMP WHERE RQST_ID = '${requestId}'

Multile_putsql.PNG

0 REPLIES 0