OF type-name

Description

Specifies that the columns of the view are based on the attributes of the structured type identified by type-name.

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

CREATE VIEW OF type-name is not supported in Snowflake.

Grammar Syntax

Sample Source Patterns

IBM DB2

Code 1

CREATE VIEW testView
OF Rootview MODE DB2SQL(REF IS oidColumn USER GENERATED)
AS SELECT * FROM testTable;

Snowflake

Code 1

-- ** MSC-ERROR - MSCEWI1021 - CREATE VIEW OF TYPE IS NOT SUPPORTED **
--CREATE VIEW testView
--OF Rootview MODE DB2SQL(REF IS oidColumn USER GENERATED)
--AS SELECT * FROM testTable

Related EWIs

1. MSCEWI1021: NODE NOT SUPPORTED