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

    • 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
    • [Webinar] Catalyst Cloud Browser in Action: PDF & Web Rendering Solutions for Regulated Industries

      Hi everyone, Have you ever struggled with rigid PDF tools or clunky rendering logic in BFSI or healthcare apps? Do your clients struggle to deliver compliant, dynamic, and automated documents — and most are still stuck with brittle, server-heavy PDF generation?
    • Announcing Catalyst Developer Bootcamps in India - Zoho Community

      Hey everyone! We're excited to announce a set of developer bootcamps dedicated to Catalyst! These bootcamps are aimed to empower developers to build, scale, and deploy applications with speed and precision, using Catalyst. Whether you're a newcomer or

      Catalyst Community