How to get Header data along with detail data in Sql Anywhere



Here, I am attaching screen shot of the issue.


My problem is, I have detail tag as Item and I am able to get data from that but along with that I want to get data from the header tag which is Success tag.


My structure is shown in attachment along with dummy xml file. Please help me to resolve the issue.


![> SELECT * FROM openxml( '





1 29004caf-5710-4769-b61b-a94074ebad8e sdfsdfs 509f91b9-c040-41f6-9273-12fefeaf4411 uXkC81eBk... hnU9MoVqId3rs0m77Vh2O5uVGBA= MIIEfzCCA2egAwIBAgITHwA... sdfsdfs 509f91b9-c040-41f6-9273-12fefeaf4411 uXkC81eBk... hnU9MoVqId3rs0m77Vh2O5uVGBA= MIIEfzCCA2egAwIBAgITHwA... ','//:Body//:item' ) WITH ( success int 'Body///:success/text()', clientDocRef long varchar ':clientDocRef',auditRef long varchar ':documents/item/auditRef',signatureValue long varchar ':documents/item/signatureValue',digestValue long varchar ':documents/item/digestValue',x509Cert long varchar ':documents/item/x509Cert' );][1]



[Screen Shot]: http://ift.tt/1ELiuKE


No comments:

Post a Comment