SSC-FDM-OR0031

The error logging clause in DML statements is not supported by Snowflake

Description

This error is used to advise that the error_logging clause in Oracle's DML statements is not supported by Snowflake's DML statements.

Example Code

Input Code:

IN -> Oracle_01.sql

MERGE INTO people_target pt 
USING people_source ps ON (pt.person_id = ps.person_id) 
WHEN MATCHED THEN UPDATE 
  SET pt.first_name = ps.first_name, 
      pt.last_name = ps.last_name, 
      pt.title = ps.title
LOG ERRORS;

Output Code:

OUT -> Oracle_01.sql

MERGE INTO people_target pt
USING people_source ps ON (pt.person_id = ps.person_id)
  WHEN MATCHED THEN
    UPDATE
    SET pt.first_name = ps.first_name,
        pt.last_name = ps.last_name,
        pt.title = ps.title
--  --** SSC-FDM-OR0031 - THE ERROR LOGGING CLAUSE IN DML STATEMENTS IS NOT SUPPORTED BY SNOWFLAKE **
--LOG ERRORS
          ;

Recommendations

• No additional user actions are required.

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