SSC-FDM-OR0016

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

Description

COMMIT and ROLLBACK statement options are being removed because Snowflake does not require them.

Example Code

Input Code

IN -> Oracle_01.sql

COMMIT WORK FORCE '22.57.53';
ROLLBACK WORK FORCE '22.57.53';

Output Code

OUT -> Oracle_01.sql

--** SSC-FDM-OR0016 - COMMIT OPTIONS REMOVED BECAUSE SNOWFLAKE DOES NOT REQUIRE THEM **
--** SSC-FDM-OR0012 - COMMIT REQUIRES THE APPROPRIATE SETUP TO WORK AS INTENDED **
COMMIT WORK;

--** SSC-FDM-OR0016 - ROLLBACK OPTIONS REMOVED BECAUSE SNOWFLAKE DOES NOT REQUIRE THEM **
--** SSC-FDM-OR0012 - ROLLBACK REQUIRES THE APPROPRIATE SETUP TO WORK AS INTENDED **
ROLLBACK WORK;

Recommendations

• If you need more support, you can email us at [e-mail]