title: Migration of XML functionality from Oracle to DB2 LUW (ver 9.7 on AIX)
body: <p>We are trying to migrate a set of Oracle PL/SQL's to DB2. We have set the Oracle compatibility vector in the db2 configuration parameters, but we are facing issues in instances where an xml file is being read in the Oracle PL/SQL code, eg:-
   <code>v_parser dbms_xmlparser.Parser;</code>
  <code>v_doc dbms_xmldom.DOMDocument;</code> 
   <code>v_nl dbms_xmldom.DOMNodeList;</code>
  <code>v_n dbms_xmldom.DOMNode;</code> 
  <code>v_parser := dbms_xmlparser.newParser;</code> </p>
  
  <p>The above sort of code does not compile in a db2 Stored Procedure, throwing error for "dbms_xmlparser" (Object not found). As per my understanding, the best approach would be to develop an equivalent code using pureXML to load the xml file into a temporay or staging table and read it from that table. Is it possible to federate on an xml file and use it as an alias directly?
   All thoughts/inputs are welcome.</p>
  
  <p>Ashwin Pande and Sandeep Pandit</p>