MSCEWI3132

COMMIT and ROLLBACK options were removed because Snowflake does not require them

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

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;

Recommendations

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