On 01.09.2017 22:01, Alexander Holupirek wrote:
On 1. Sep 2017, at 19:41, Ron Katriel rkatriel@mdsol.com wrote: Is there a way simpler way around this - other than modifying the input header to remove the namespace declaration?
declaring a default element in your XQuery might help?
declare default element namespace "http://www.drugbank.ca"; for $drug in doc('drugbank.Lepirudin.ATC.fail.xml')/drugbank/drug where not(empty($drug/atc-codes/atc-code)) return <drug> {
But that would also put the result elements into that namespace, not sure whether that is wanted.