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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.