declare namespace esb = "http://www.ferguson.com/esb";
declare namespace a = "http://www.openapplications.org/oagis/9";
{
for $Order in doc('converter:file:///c:/test_xml/m2.conv?file:///c:/test_xml/edi856_o.dat')/root/Order
return
{
$Order/Orderno/text()
}
{
$Order/Customer/text()
}
{
$Order/City/text()
}
{
$Order/Zip/text()
}
{
for $component1 in $Order/linedetail/component
return
{
$component1/po/text()
}
{
$component1/item/text()
}
{
$component1/custitem/text()
}
{
$component1/des1/text()
}
{
$component1/des2/text()
}
{
$component1/qty/text()
}
{
$component1/uom/text()
}
}
}
(: Stylus Studio meta-information - (c) 2004-2008. Progress Software Corporation. All rights reserved.
:)