Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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