XMLEXISTS Predicate

Description

The XMLEXISTS predicate tests whether an XQuery expression returns a sequence of one or more items.

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

Grammar Syntax

Sample Source Patterns

IBM DB2

   SELECT c.cid FROM customer c
     WHERE XMLEXISTS('$d/*:customerinfo/*:addr[ *:city = "Aurora" ]'
       PASSING info AS "d");

Snowflake

   SELECT c.cid FROM customer c /*** MSC-ERROR - MSCEWI1073 - PENDING FUNCTIONAL EQUIVALENCE REVIEW FOR 'AsCorrelationName' NODE ***/
     WHERE /*** MSC-ERROR - MSCEWI1021 - XMLEXISTS NOT SUPPORTED ***/
 PUBLIC.XMLEXISTS_UDF('XMLEXISTS(\'$d/*:customerinfo/*:addr[ *:city = "Aurora" ]\'       PASSING info AS "d")');

  1. MSCEWI1021: Not supported.

Last updated

Was this helpful?