×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Hi all
i'm doing some test with XMLPARSE ....
i would like to Parse this XML file
<?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>
so i wrote this code on Acs SQL Script
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;
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
midrange.com
