MSCEWI5010

ATTRIBUTE NAME IS NOT SUPPORTED IN SNOWFLAKE

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

Severity

Medium

Description

This message is displayed when specifying the attribute of a structured type that is being set (called an attribute assignment). A structured type can be a subtype that allows attributes to be inherited from a supertype.

Snowflake does not support these types of structures.

For more information about structure types click here

Code Example

DB2

UPDATE CIRCLES
     SET C..CENTER..X = C..CENTER..Y,
       C..CENTER..Y = C..CENTER..X
     WHERE ID = 999;

Snowflake

-- ** MSC-ERROR - MSCEWI5011 - ATTRIBUTE NAME IS NOT SUPPORTED IN SNOWFLAKE **
--UPDATE CIRCLES
--     SET C..CENTER..X = C..CENTER..Y,
--       C..CENTER..Y = C..CENTER..X
--     WHERE ID = 999

Recommendations

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