WITH ROW MOVEMENT

Description

Specifies the action to take for an updatable UNION ALL view when a row is updated in a way that violates a check constraint on the underlying table.

Click here to navigate to the IBM DB2 docs page for this syntax.

WITH ROW MOVEMENT is not supported in Snowflake.

Grammar Syntax

Sample Source Patterns

IBM DB2

Code 1

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

Snowflake

Code 1

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

Related EWIs

1. MSCEWI5005: MANIPULATION OF DATA IN VIEWS IS NOT SUPPORTED