MSCEWI2088

LAYOUT was not found

Severity

Low

Description

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

Example code

Input code

.IMPORT INFILE C:\USER\user\my_tr_file_1.tr
  FORMAT UNFORMAT 
  LAYOUT not_layout APPLY insert_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 not_layout APPLY insert_into_my_table*/
       
      /*** MSC-WARNING - MSCEWI2088 - LAYOUT not_layout WAS NOT FOUND ***/
       
    END;

Recommendations

Last updated