Re: Help with XMLPARSE

[Alex Martínez <ajut400@xxxxxxxxx>]

Hi, I have tested them in v7r1 modifying COLUMNS PATH

HTH

CountryCode char(02) Path '*:countryCode',

VatNumber char(10) Path '*:vatNumber',

RequestDate char(20) Path '*:requestDate',

Valid char(10) Path '*:valid' )

El dom, 2 ene 2022 a las 15:40, gio.cot via MIDRANGE-L (<
midrange-l@xxxxxxxxxxxxxxxxxx>) escribió:

> 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/ <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
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com