Hello All,
I work on db2 v9.7. I have a XML as below
<ns1:IPSPharmacyClaimMessage RecordTimestamp="2010-05-18T13:47:27.000000" MessageID="3ED25804DD5A1929A68C0004AC137813" xmlns:ns1="urn:ws.ips.primetherapeutics.com/ips-bcbsmn-pharmacy-claim-memo.xsd/2008/01">
-
<ns1:PharmacyClaimInfo>
-
<ns1:Eligibility GroupID="Y0325AC" EmployerID="J894" CarrierID="PGIGN" AccountID="BLUMNA">
<ns1:Patient SSN="000000000" RelationshipCode="Cardholder" PersonCode="000" MemberID="XZ298193400" LastName="BROTHERS" GenderCode="M" FirstName="MARIO" FamilyID="XZ2981934" DateOfBirth="1949-01-03" />
<ns1:Subscriber SubscriberID="XZ4003579" SSN="000000000" PersonCode="000" LastName="BROTHERS" GenderCode="M" FirstName="M" DateOfBirth="1949-01-03" />
</ns1:Eligibility>
-
<ns1:PharmacyClaimDetail SubmittedDate="2010-05-18" RxNumberQualifier="RxBilling" RxNumber="1443133" ProfessionalServiceFee="0" ProductType="03" ProductNumber="65483009306" PlanPayAmount="0" PlanPaidTax="0" PharmacyNumberQualifier="07" PharmacyNumber="2415253" PatientPayTax="0" PatientPayAmount="40.00" PSC="0" OverCap="0" OtherPaidAmount="0" IncentiveFee="0" FinalPlanCode="MNAF3005" FillDate="2012-01-01" DispensingFee="0" DiscountAmount="40.00" Deductible="40.00" CopayPercentageAmount="0" CopayFlatAmount="0" ClaimStatus="Paid" ClaimSequenceNumber="999" ClaimNumber="999222777666050" Amount="40.00">
-
<ns1:Accumulators>
<ns1:Accumulator Type="Deductible" SubType="BOTH" SendAmountApplied="40.00" ScheduleID="MNC300014" PeriodEndDate="2010-12-31" PeriodBeginDate="2009-10-01" OwnerType="Member" IntegrationType="Internal" IntegratedPharmMed="false" IntegratedAmountApplied="40.00" IndividualUndefinedAdjustmentTotal="0" IndividualPharmacyAdjustmentTotal="0" IndividualMedicalAdjustmentTotal="0" IndividualClaimTotal="40.00" IndividualBenefitToDate="40.00" IndividualAmountRemaining="960.00" FamilyUndefinedAdjustmentTotal="0" FamilyPharmacyAdjustmentTotal="0" FamilyMedicalAdjustmentTotal="0" FamilyClaimTotal="40.00" FamilyBenefitToDate="40.00" FamilyAmountRemaining="2960.00" ComponentCode="5" BasisCode="3" />
<ns1:Accumulator Type="OutOfPocket" SubType="BOTH" SendAmountApplied="30.30" ScheduleID="MNC300009" PeriodEndDate="2010-12-31" PeriodBeginDate="2009-10-01" OwnerType="Member" IntegrationType="Internal" IntegratedPharmMed="false" IntegratedAmountApplied="40.00" IndividualUndefinedAdjustmentTotal="0" IndividualPharmacyAdjustmentTotal="0" IndividualMedicalAdjustmentTotal="0" IndividualClaimTotal="40.00" IndividualBenefitToDate="40.00" IndividualAmountRemaining="460.00" FamilyUndefinedAdjustmentTotal="0" FamilyPharmacyAdjustmentTotal="0" FamilyMedicalAdjustmentTotal="0" FamilyClaimTotal="40.00" FamilyBenefitToDate="40.00" FamilyAmountRemaining="960.00" ComponentCode="5" BasisCode="3" />
<ns1:Accumulator Type="LifetimeMax" SubType="BOTH" SendAmountApplied="7.92" ScheduleID="MNC5MIL*I" OwnerType="Member" IntegrationType="Internal" IntegratedPharmMed="false" IntegratedAmountApplied="7.92" IndividualUndefinedAdjustmentTotal="0" IndividualPharmacyAdjustmentTotal="0" IndividualMedicalAdjustmentTotal="213555.49" IndividualClaimTotal="34698.39" IndividualBenefitToDate="248253.88" IndividualAmountRemaining="4751746.12" FamilyUndefinedAdjustmentTotal="0" FamilyPharmacyAdjustmentTotal="0" FamilyMedicalAdjustmentTotal="222644.31" FamilyClaimTotal="0" FamilyBenefitToDate="0" FamilyAmountRemaining="0" ComponentCode="2" BasisCode="1" />
</ns1:Accumulators>
</ns1:PharmacyClaimDetail>
</ns1:PharmacyClaimInfo>
</ns1:IPSPharmacyClaimMessage>


Can anyone help to with the XML query to search on the MessageID="3ED25804DD5A1929A68C0004AC137813".
I tried the below query and both does not fetch the XLM

SELECT * FROM logaudit.pharm_req WHERE XMLEXISTS ('$d//IPSPharmacyClaimMessage' passing PHAR_REQ_DOC as "d");
SELECT * FROM logaudit.pharm_req WHERE XMLEXISTS ('$d/.[*:MessageID' passing logaudit.pharm_req.PHAR_REQ_DOC as "d");

Thanks a lot for your help in advance.