EXECUTE

Description

EXECUTE is used to execute a previously prepared statement

Click here to navigate to the PostgreSQL documentation page for this syntax.

Execute is partially supported by Snowflake.

Grammar Syntax

EXECUTE name [ ( parameter [, ...] ) ]

Sample Source Patterns

EXECUTE is translated to EXECUTE IMMEDIATE, and the EXECUTE of a function is translated to a CALL statement.

Input

PostgreSQL

EXECUTE 'ALTER TABLE "' || t_schema || '"."' || t_table || '" OWNER TO "' || t_owner || '"';

EXECUTE func1(param);

EXECUTE (query) into myVar;

Snowflake

EXECUTE IMMEDIATE 'ALTER TABLE "' || t_schema || '"."' || t_table || '" OWNER TO "' || t_owner || '"';

CALL func1(param);

EXECUTE IMMEDIATE (query)
-- ** MSC-ERROR - MSCEWI1021 - EXECUTE IMMEDIATE RETURNING CLAUSE NOT SUPPORTED **
--                                into myVar
                                                  ;

Known Issues

The use of INTO clause in the EXECUTE statement is not supported en Snowflake.

Take in consideration that the expression being executed maybe not supported by Snowflake.

Related EWIs

1. MSCEWI1021: Not Supported.