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}'