doc() funciton in for loop
File: Data.xml <prod:car xmlns:prod="http://java2s.com/prod"> <prod:id>0002</prod:id> <prod:name language="en">name 2</prod:name> </prod:car> File: Query.xquery declare namespace cat = "http://java2s.com/cat"; <report xmlns="http://java2s.com/report" xmlns:prod="http://java2s.com/prod"> { for $car in doc("Data.xml")/prod:car return <linecar> {$car/prod:id} {$car/prod:name} </linecar> } </report> Output: <?xml version="1.0" encoding="UTF-8"?> <report xmlns:prod="http://java2s.com/prod" xmlns="http://java2s.com/report"> <linecar> <prod:id>0002</prod:id> <prod:name language="en">name 2</prod:name> </linecar> </report>