name spaces in db2 Xquery

[sudheerdb2]

Hi,

I am trying xml data processing using Xquery version 9.1

My xml file

---------

<?xml version="1.0" ?>
<S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/">
<S:Body>
<GetBookingDetailsResponse
xmlns="http://types.xml.bookingquery.myproject.ws.clientname.com ">
<record>
<id>123</id>
……
</record>

-------------
To get id value i.e “123” fallowing query will work if I remove above name spaces in xml file

select XMLCAST(xmlquery('$id/record/id' passing info as "id"), name AS VARCHAR(25)) from src_tab

but according to my requirement I can’t remove that xmlns from xml.

So please tell me how to handle names spaces in xquery.

Can I have example query for above situation.

Appreciate for early replies.

Thanks and regards
s