MSCEWI2089

DML label was not found

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

Severity

Low

Description

The warning is show when DML label used in import clause in not found.

Example code

Input code

.IMPORT INFILE C:\USER\user\my_tr_file_1.tr
  FORMAT UNFORMAT 
  LAYOUT my_layout APPLY insert_not_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 insert_not_my_table*/
       
      /*** MSC-WARNING - MSCEWI2089 - DML LABEL insert_not_my_table WAS NOT FOUND ***/
       
    END;

Recommendations

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