This is a deprecated version of the SnowConvert documentation, please visit the official site .
Severity
Low
Description
COMMIT and ROLLBACK statement options are being removed because Snowflake does not require them.
Example Code
Input Code
COMMIT WORK FORCE '17-01-2023';
ROLLBACK WORK FORCE '17-01-2023';
Output Code
/*** MSC-WARNING - MSCEWI3131 - COMMIT REQUIRES THE APPROPRIATE SETUP TO WORK AS INTENDED ***/
/*** MSC-WARNING - MSCEWI3132 - COMMIT OPTIONS REMOVED BECAUSE SNOWFLAKE DOES NOT REQUIRE THEM ***/
COMMIT WORK;
/*** MSC-WARNING - MSCEWI3131 - ROLLBACK REQUIRES THE APPROPRIATE SETUP TO WORK AS INTENDED ***/
/*** MSC-WARNING - MSCEWI3132 - ROLLBACK OPTIONS REMOVED BECAUSE SNOWFLAKE DOES NOT REQUIRE THEM ***/
ROLLBACK WORK;