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 Multile_putsql.PNG](https://community.cloudera.com/t5/image/serverpage/image-id/39493iDAC23FB6472EC0E3/image-size/medium?v=v2&px=400)