How to Import an XML File within a Batch Job
Suppose an XML file contains row elements with processing instructions, for example:
<PERSON ID="177" FAMILY_NAME="Haynes" FIRST_NAME="Deborah">
<PERSON ID="112" FAMILY_NAME="Smith" FIRST_NAME="John">
You can process these row elements with their instructions by defining an import task that invokes the internal XML.import method.
To import an XML file within a batch job:
SELECT DOCUMENT XMLDocument
For more information about the internal XML component, please refer to the Definer Help topic: "The XML Import Method".