MSCEWI5005

MANIPULATION OF DATA IN VIEWS IS NOT SUPPORTED

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

Severity

Medium

Description

This message is shown when it is found in a CREATE VIEW a node or clause that is related to the data manipulation of rows in a CREATE VIEW. Note that in DB2 you can insert or update rows directly from a VIEW meanwhile in Snowflake this is not supported, because of this, nodes or clauses related to this functionality are commented and an EWI is added.

Code example

Input code:

CREATE VIEW TestTableId2 AS Select * from TestTableId1 WITH ROW MOVEMENT;
CREATE VIEW TestTableId2 AS Select * from TestTableId1 WITH CASCADED CHECK OPTION ;

Output code:

CREATE VIEW PUBLIC.TestTableId2
AS Select * from TestTableId1
-- ** MSC-ERROR - MSCEWI5005 - MANIPULATION OF DATA IN VIEWS IS NOT SUPPORTED. **
--                              WITH ROW MOVEMENT
                                               ;
CREATE VIEW PUBLIC.TestTableId2
AS Select * from TestTableId1
-- ** MSC-ERROR - MSCEWI5005 - MANIPULATION OF DATA IN VIEWS IS NOT SUPPORTED. **
--                              WITH CASCADED CHECK OPTION
                                                         ;

Recommendations

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