TYPE Predicate

Description

A TYPE predicate compares the type of an expression with one or more user-defined structured types.

TYPE Predicate is not supported in Snowflake.

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

Grammar Syntax

Sample Source Patterns

IBM DB2

Code

   SELECT Name
      FROM Employee E
      WHERE E.Age > 35 AND
      DEREF(E.Oid) IS OF (Manager_t, Architect_t);

Snowflake

Code

   SELECT Name
      FROM Employee E /*** MSC-ERROR - MSCEWI1073 - PENDING FUNCTIONAL EQUIVALENCE REVIEW FOR 'AsCorrelationName' NODE ***/
      WHERE E.Age > 35 AND /*** MSC-ERROR - MSCEWI1021 - TYPE_EXPRESSION NOT SUPPORTED ***/
 PUBLIC.TYPE_EXPRESSION_UDF('DEREF(E.Oid) IS OF (Manager_t, Architect_t)');

Related EWIs

1. MSCEWI1021: Not supported.