Transactional Integrity in Data Store

Transactional Integrity in Data Store

In my Data Store, I want to subtract quantities from some tables, add them to others and subtract them from others. However, I want to make sure that if one operation fails, the others are reverted, or don't occur. In SQL I know I can achieve this like:
  1. BEGIN TRANSACTION;
INSERT INTO table1 (column1, column2) VALUES (value1, value2);
DELETE FROM table2 WHERE condition;
UPDATE table3 SET column1 = value1 WHERE condition;
COMMIT;
ROLLBACK;

This way, I ensure that my data keeps integrity and is synchronised. My understanding is that ZCQL doesn't support this. How's the best way to achieve something like this in Catalyst?

    • Announcements

    • Introducing GenAI Features in Catalyst QuickML

      Hi everyone, Building machine learning models can often feel slow and complex, especially when teams wait for perfect certainty before testing their ideas. But in reality, faster progress comes from early experimentation—trying out models quickly, learning

    • Announcing Deprecation of Catalyst File Store, Event Listeners, and Cron

      We would like to announce that the following Catalyst features are now in their deprecation phase and will reach End Of Life (EOL) on 30 April, 2026- Catalyst File Store Catalyst Event Listeners Catalyst Cron New users who sign up for Catalyst from today

    • React Nexus 2025 Recap: Catalyst Slate in Action!

      Hey Catalyst Community! We recently attended the React Nexus 2025 conference, an exciting gathering for frontend enthusiasts and React developers. Our team had an incredible time presenting and conducting a hands-on workshop on Catalyst Slate, our streamlined

    • [Webinar] A hands-on guide to Catalyst Stratus

      Have you used Catalyst Stratus yet? It’s an object storage service that makes it easy to handle large files — whether they're coming from your Catalyst app or other Zoho apps. We’re hosting a live coding session where you’ll build a working prototype

    • Catalyst Video Tutorials!

      Hello everyone! We’ve been brewing something exciting behind the scenes, and we’re thrilled to finally share it with you- Catalyst video tutorials are here! We recognized that videos are the predominant medium for learning and discovery these days, so

      Catalyst Community