Hi all
i'm doing some test with XMLPARSE ....
i would like to Parse this XML file
so i wrote this code on Acs SQL Script
But when i try to run it i receive SQL error SQL0443
can some one help to understand where am i wrong ? i should run tjis in V7R1
Thanks in advance
Gio
i'm doing some test with XMLPARSE ....
i would like to Parse this XML file
Code:
<?xml version="1.0" encoding="UTF-8"?> <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/ envelope/"> <soapenv:Body> <urn:checkVatResponse xmlns:urn="urn:ec.europa.eu:taxud:vies:services:ch eckVat:types"> <urn:countryCode>FR</urn:countryCode> <urn:vatNumber>59431790310</urn:vatNumber> <urn:requestDate>2010-10-19+02:00</urn:requestDate> <urn:valid>true</urn:valid> </urn:checkVatResponse> </soapenv:Body> </soapenv:Envelope>
Code:
SELECT x.* FROM XMLTABLE( '$doc/*:Envelope/*:Body/*:checkVatResponse' PASSING XMLPARSE(DOCUMENT GET_XML_FILE('/tmp/mflr/fqxml.xml')) AS "doc" COLUMNS CountryCode char(02) Path 'countryCode', VatNumber char(10) Path 'vatNumber', RequestDate char(20) Path 'requestDate', Valid char(10) Path 'valid' ) AS x;
can some one help to understand where am i wrong ? i should run tjis in V7R1
Thanks in advance
Gio
Comment