VALIDATED Predicate

Description

The VALIDATED predicate tests whether or not the value specified by XML-expression has been validated using the XMLVALIDATE function.

VALIDATED 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 XMLCOL FROM T1
     WHERE XMLCOL IS VALIDATED;

Snowflake

Code

   SELECT XMLCOL FROM T1
     WHERE /*** MSC-ERROR - MSCEWI1021 - VALIDATED_PREDICATE NOT SUPPORTED ***/
 PUBLIC.VALIDATED_PREDICATE_UDF('XMLCOL IS VALIDATED');

Related EWIs

1. MSCEWI1021: Not supported.