XMLEXISTS Predicate
Last updated
Was this helpful?
Last updated
Was this helpful?
Was this helpful?
SELECT c.cid FROM customer c
WHERE XMLEXISTS('$d/*:customerinfo/*:addr[ *:city = "Aurora" ]'
PASSING info AS "d"); 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")');