REPEAT

Translation reference to convert Teradata REPEAT statement to Snowflake Scripting

Description

Teradata's REPEAT statement is translated to Snowflake Scripting REPEAT syntax.

For more information on Teradata Repeat, check here.

[label_name:] REPEAT 
    { sql_statement }
    UNTIL conditional_expression
END REPEAT [label_name];

Sample Source Patterns

Teradata

Repeat

CREATE PROCEDURE repeatProcedure(OUT resultCounter INTEGER)
BEGIN
    DECLARE counter INTEGER DEFAULT 0;
   
    customeLabel: REPEAT 
    	SET counter = counter + 1;
	UNTIL 10 < counter    
    END REPEAT customeLabel;
   
    SET resultCounter = counter;
END;

CALL repeatProcedure(:?);

Result

|resultCounter|
|-------------|
|11           |

Snowflake Scripting

Repeat

CREATE OR REPLACE PROCEDURE PUBLIC.repeatProcedure (/*** MSC-ERROR - MSCEWI1058 - FUNCTIONALITY FOR 'OUT PARAMETERS' IS NOT CURRENTLY SUPPORTED BY SNOWFLAKE SCRIPTING ***/
RESULTCOUNTER FLOAT)
RETURNS VARCHAR
LANGUAGE SQL
EXECUTE AS CALLER
AS
$$
   BEGIN
      LET counter INTEGER DEFAULT 0;
      REPEAT
         counter := counter + 1;
      UNTIL ( 10 < counter)
      END REPEAT CUSTOMELABEL;
      resultCounter := counter;

      RETURN resultCounter;
   END;
$$;

CALL repeatProcedure(1);

Result

|REPEATPROCEDURE|
|---------------|
|1             |

Known Issues

No issues were found.

Related EWIs

No related EWIs.