MSCEWI1094

Label declaration not supported

Severity
Low
Description
Currently there is no equivalent for labels declaration in Snow Scripting, so an EWI is added, and the label is commented out
Example Code
Input Code:
CREATE OR REPLACE PROCEDURE Example ( grade NUMBER )
IS
BEGIN
	<<CASE1>><<CASE2>>
	CASE grade
		WHEN 10 THEN NULL;
		ELSE NULL;
	END CASE CASE1;
END;
Output Code:
CREATE OR REPLACE PROCEDURE PUBLIC.Example (grade FLOAT )
RETURNS VARCHAR
LANGUAGE SQL
EXECUTE AS CALLER
AS
$$
   BEGIN
      /*** MSC-WARNING - MSCEWI1094 - LABEL DECLARATION FOR A STATEMENT IS NOT SUPPORTED BY SNOWFLAKE SCRIPTING ***/
      /*<<CASE1>><<CASE2>>*/
      CASE grade
         WHEN 10 THEN
            NULL;
         ELSE
            NULL;
      END CASE;
   END;
$$;
Recommendations
No end-user action is required.
For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.

MSCEWI1093

MSCEWI1095

Last modified 3mo ago