7 Replies Latest reply on Feb 27, 2018 5:13 PM by Steven Hawkins

    xmltable/xmlparse of standalone.xml

    virtualdatabase Apprentice

      Everyone.. I'm having difficulty parsing the standalone.xml file

       

      I need to pull portions of info from the standalone.xml file.  For now, I'm simply wanting to pull the information from the datasources section.


      Any input would be most appreciated.

       

      select x.* from (SELECT to_chars(a.file, 'UTF-8') AS File

      FROM (EXEC SystemFileReader.getFiles('./standalone/configuration/standalone.xml')) AS a,

      XMLTABLE('/datasources' PASSING XMLPARSE(DOCUMENT a.File) columns JNDI_Name string PATH '@name')) as x