ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Help with XMLPARSE

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Help with XMLPARSE

    Hi all
    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>
    so i wrote this code on Acs SQL Script

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



  • #2
    Hi All
    just to inform you that the problem was due to the IFS CCSID .. settint this to 819, now is working
    Thanks

    Comment

    Working...
    X