R: Help with XMLPARSE

["Giovanni Arturi" <giovanni.arturi@xxxxxxxxx>]

Hi 
I have also tried to run this SQL script on V7R2 but the errori s the same .. so i would think that is not a PTF problem
Thanks again
Gio 

> Hi Alex
> Thanks for you reply 

> I tried in this way, but i receive the same error

> SELECT x.* FROM
> XMLTABLE(
>   '$doc/*:Envelope/*:Body/*:checkVatResponse' PASSING XMLPARSE(DOCUMENT GET_XML_FILE('/tmp/myfile/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;

pheraps is a PTF problem ? 


> 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
--
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

--
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