DB2 匿名 SQL 块的有效语法是什么

DB2匿名SQL块的有效语法

BEGIN ATOMIC
-- SQL statements
END

BEGIN ATOMIC
DECLARE total INT DEFAULT 0;
DECLARE product_name VARCHAR(50);
DECLARE c CURSOR FOR
    SELECT DISTINCT product_name FROM Sales;
OPEN c;
LOOP
    FETCH c INTO product_name;
    IF SQLSTATE = '02000' THEN
        LEAVE;
    END IF;
    
    SELECT SUM(sales_quantity) INTO total
    FROM Sales
    WHERE product_name = product_name;
    
    INSERT INTO ProductTotal (product_name, total_quantity)
    VALUES (product_name, total);
END LOOP;
CLOSE c;
END