Options
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Run Multiple Update Statements Transitionally
Labels:
- Labels:
-
Apache NiFi
Contributor
Created 01-18-2024 01:12 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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}'
0 REPLIES 0
