I have an XML file with about 11,000 elements and each element has about 50 attributes which I need to read and convert into a SQL INSERT statement. I have it working but reading each element and then each attribute (11,000 X 50) creates about 550,000 AMXML ACTIVITY="read_node" events which is EXTREMELY slow.
I'm currently looking through the list of 50 attributes (stored in an array) then reading each attribute into a variable which is then concatenated to create a SQL INSERT statement. Can I read multiple XML attributes into a dataset instead of reading them one at a time into a variable?
<AMXML ACTIVITY="read_node" SESSION="XML-READ" XPATH="/Report//ReportItem[%ITEM%]" ATTRNAME="%ATTR%" RESULTVARIABLE="VALUE" />