MSCEWI2090

Conditions not found in update statement for transformation

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

Severity

Low

Description

The warning is show when conditions in update statement are not found

Example code

Input code

UPDATE my_table  
 SET     
  col1 = :col1,     
  col2 = :col2
INSERT INTO my_table (
col1, col2)  
VALUES (:col1, :col2);

.IMPORT INFILE C:\USER\user\my_tr_file_1.tr
  FORMAT UNFORMAT 
  LAYOUT my_layout APPLY upsert_into_my_table;

Output code

BEGIN
      CREATE OR REPLACE STAGE &{stagename};
      PUT file://C:\USER\user\my_tr_file_1.tr &{stagename};
      /*** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE.  ***/
      /*.IMPORT INFILE C:\USER\user\my_tr_file_1.tr
        FORMAT UNFORMAT
        LAYOUT my_layout APPLY upsert_into_my_table;*/
        
      /*** MSC-WARNING - MSCEWI2090 - CONDITIONS NOT FOUND IN UPDATE STATEMENT FOR TRANSFORMATION ***/     
        
    END;

Recommendations

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