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
SELECT XMLCOL FROM T1
WHERE XMLCOL IS VALIDATED;
Snowflake
SELECT XMLCOL FROM T1
WHERE /*** MSC-ERROR - MSCEWI1021 - VALIDATED_PREDICATE NOT SUPPORTED ***/
PUBLIC.VALIDATED_PREDICATE_UDF('XMLCOL IS VALIDATED');
Related EWIs
MSCEWI1021: Not supported.
Last updated
Was this helpful?