I'd like to select several elements from a XML document and tried to combine several simple XPath queries with the pipe operator as logical OR, such as
'//GivenName | //SurName'
It seems that SQL Anywhere does not support that but raises error -892: "XPath parser error: syntax error at or before character '|'".
This is similar to that (still unanswered) FAQ on position tests in XPath queries.
Just to clarify this one: Am I right that ORing XPath expressions is not (yet) supported?
If so, are there better workarounds than
Checking the XML parser code, yes, I can confirm that
I have now made an enhancement request to look at further potential support for XPath queries in OPENXML (set operations, and boolean/comparison/set expressions) in CR #740332 for a future version of SQL Anywhere. I hope that's a more helpful hint. ;)
answered 23 May '13, 14:52