SSC-FDM-OR0012

COMMIT and ROLLBACK statements require adequate setup to perform as intended.

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

Description

COMMIT and ROLLBACK statements require adequate setup to perform as intended in Snowflake. The following instruction needs to be executed in Snowflake to simulate the correct functionality of these statements:

ALTER SESSION SET AUTOCOMMIT = false;

Example Code

Input Code

IN -> Oracle_01.sql

COMMIT;
ROLLBACK;

Output Code

OUT -> Oracle_01.sql

--** SSC-FDM-OR0012 - COMMIT REQUIRES THE APPROPRIATE SETUP TO WORK AS INTENDED **
COMMIT;

--** SSC-FDM-OR0012 - ROLLBACK REQUIRES THE APPROPRIATE SETUP TO WORK AS INTENDED **
ROLLBACK;

Recommendations

• Execute the query mentioned in the description section before you start to execute your code.

• If you need more support, you can email us at [email protected].