MSCEWI3132

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

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