MSCEWI5012

INVALID NAME AS INSERTION TARGET, USE OF VIEW NAME IS NOT SUPPORTED IN SNOWFLAKE

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Medium

Description

Snowflake does not support the use of view name in the insert target name statement. For this reason, the complete Delete statement will be commented out with this EWI

Code Example

DB2

CREATE VIEW VIEW1 AS SELECT * FROM T;
INSERT INTO VIEW1 (COL1, COL2) VALUES (NULL, DEFAULT);

Snowflake

CREATE VIEW PUBLIC.VIEW1
AS SELECT * FROM
PUBLIC.T;

-- ** MSC-ERROR - MSCEWI5012 - INVALID NAME AS INSERTION TARGET, USE OF VIEW NAME IS NOT SUPPORTED IN SNOWFLAKE **
--INSERT INTO VIEW1 (COL1, COL2) VALUES (NULL,DEFAULT)

Recommendations

• If you need more support, you can email us at [email protected]