XML reading from datastage
Posted: Fri Feb 24, 2006 12:00 am
Hi ,
this is my xml file i didn't give complete file ,
<?xml version="1.0" encoding="UTF-8"?>
<SEND_SUPPLIER_INVOICE xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="urn:ifsworld-com:schemas:send_supplier_invoice">
<DATA_AREA>
<INVOICE>
<invoice no>...</invoice no>
<invoice id>...</<inovice id>
<CURRENCY_CODE>USD</CURRENCY_CODE>
<CURRENCY_RATE>1</CURRENCY_RATE>
<DELIVERY_DATE xsi:nil="1"/>
<DUE_DATE>2006-11-09</DUE_DATE>
<FACTOR>1</FACTOR>
<IDENTITY_ID>NN36</IDENTITY_ID>
<INVOICE_DATE>2006-10-10</INVOICE_DATE>
</INVOICE_ACCOUNTING_ROW>
.....
</INVOICE_ACCOUNTING_ROWS>
</INVOICE_ITEM>
.....
</INVOICE_ITEMS>
....
</INVOICE>
</DATA_AREA>
</SEND_SUPPLIER_INVOICE>
This my xml , from datastage i should read this xml file based on tag... that is <invoice> tag record is treated as
001 record in target file, <invoice_accounting_row> is treated as 002 record in target file and <invoice_item>
is treated as 0003 record how do we achive this in datastage.
i tried datastage folerstage and xml input but there is no option for reading xml based on tag to spilt one row
into mulitple row...!
Please any give suggestion to solve this problem.
this is my xml file i didn't give complete file ,
<?xml version="1.0" encoding="UTF-8"?>
<SEND_SUPPLIER_INVOICE xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="urn:ifsworld-com:schemas:send_supplier_invoice">
<DATA_AREA>
<INVOICE>
<invoice no>...</invoice no>
<invoice id>...</<inovice id>
<CURRENCY_CODE>USD</CURRENCY_CODE>
<CURRENCY_RATE>1</CURRENCY_RATE>
<DELIVERY_DATE xsi:nil="1"/>
<DUE_DATE>2006-11-09</DUE_DATE>
<FACTOR>1</FACTOR>
<IDENTITY_ID>NN36</IDENTITY_ID>
<INVOICE_DATE>2006-10-10</INVOICE_DATE>
</INVOICE_ACCOUNTING_ROW>
.....
</INVOICE_ACCOUNTING_ROWS>
</INVOICE_ITEM>
.....
</INVOICE_ITEMS>
....
</INVOICE>
</DATA_AREA>
</SEND_SUPPLIER_INVOICE>
This my xml , from datastage i should read this xml file based on tag... that is <invoice> tag record is treated as
001 record in target file, <invoice_accounting_row> is treated as 002 record in target file and <invoice_item>
is treated as 0003 record how do we achive this in datastage.
i tried datastage folerstage and xml input but there is no option for reading xml based on tag to spilt one row
into mulitple row...!
Please any give suggestion to solve this problem.