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