MSCEWI2089

DML label was not found

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

Last updated