Generating Column names in XML Input Stage
Posted: Thu Aug 06, 2009 12:38 am
Was following this guide to read from xml file and write to a table.
http://www.ibm.com/developerworks/data/ ... 0703xiong/
However, columns are not getting generated after mentioning the namespace declaration as:
--------------------------------------------------------------
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
---------------------------------------------------------------
Could you please suggest where I'm I going wrong?
Thank you.
=============
Source file looks like:
=============
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<ase:aseXML xmlns:ase="urn:aseXML:r22" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="urn:aseXML:r22 http://www.nemmco.com.au/aseXML/schemas ... ML_r22.xsd">
<Header>
<From description="NEMMCO">NEMMCO</From>
<To description="SPI Electricity Pty Ltd">EASTERN</To>
<MessageID>a4eca52a-1816-444a-be71-279664e30f92</MessageID>
<MessageDate>2009-07-20T15:13:49+10:00</MessageDate>
<TransactionGroup>CATS</TransactionGroup>
<Priority>Medium</Priority>
<SecurityContext>None</SecurityContext>
<Market>NEM</Market>
</Header>
<Transactions>
<Transaction transactionID="a4eca52a-1816-444a-be71-279664e30f92" transactionDate="2009-07-20T15:13:49+10:00">
<ReportResponse version="r10">
<ReportParameters xsi:type="ase:CATSSnapshotReportParameters">
<ReportName>Snapshot</ReportName>
<Participant>EASTERN</Participant>
<AsAtDateTime>2009-07-20T15:13:49+10:00</AsAtDateTime>
<Tables>
<Table>CATS_METER_REGISTER</Table>
</Tables>
<LastSequenceNumber>1</LastSequenceNumber>
</ReportParameters>
<ReportResults xsi:type="ase:ReplicationReportFormat">
<ReplicationBlock tableName="ElectricityNMIMeters">
<Row xsi:type="ase:ElectricityNMIMeterRow">
<SequenceNumber>14941778</SequenceNumber>
<CreationDate>2003-12-16T11:49:27+10:00</CreationDate>
<MaintenanceDate>9999-12-31T00:00:00+10:00</MaintenanceDate>
<RowStatus>A</RowStatus>
<FromDate>2003-12-15T00:00:00+10:00</FromDate>
<ToDate>9999-12-31T00:00:00+10:00</ToDate>
<NMI>2001152666</NMI>
<SerialNumber>728653</SerialNumber>
<NextScheduledReadDate>2009-09-02</NextScheduledReadDate>
<Location>60</Location>
<Hazard>1</Hazard>
<InstallationTypeCode>BASIC</InstallationTypeCode>
<Route>62051</Route>
<Manufacturer>Email</Manufacturer>
<Model>YA1625</Model>
<Constant>1</Constant>
<Status>C</Status>
</Row>
<Row xsi:type="ase:ElectricityNMIMeterRow">
<SequenceNumber>19609933</SequenceNumber>
<CreationDate>2004-09-23T02:15:46+10:00</CreationDate>
<MaintenanceDate>9999-12-31T00:00:00+10:00</MaintenanceDate>
<RowStatus>A</RowStatus>
<FromDate>2004-09-21T00:00:00+10:00</FromDate>
<ToDate>9999-12-31T00:00:00+10:00</ToDate>
<NMI>2001217326</NMI>
<SerialNumber>293563</SerialNumber>
<NextScheduledReadDate>2009-09-08</NextScheduledReadDate>
<Location>60</Location>
<Hazard>28</Hazard>
<InstallationTypeCode>BASIC</InstallationTypeCode>
<Route>65351</Route>
<Manufacturer>Landis & Gyr</Manufacturer>
<Model>YA1841_5</Model>
<Constant>1</Constant>
<Status>C</Status>
</Row>
</ReplicationBlock>
</ReportResults>
<Event severity="Information">
<Code>0</Code>
<Explanation>Success</Explanation>
</Event>
</ReportResponse>
</Transaction>
</Transactions>
</ase:aseXML>
http://www.ibm.com/developerworks/data/ ... 0703xiong/
However, columns are not getting generated after mentioning the namespace declaration as:
--------------------------------------------------------------
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
---------------------------------------------------------------
Could you please suggest where I'm I going wrong?
Thank you.
=============
Source file looks like:
=============
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<ase:aseXML xmlns:ase="urn:aseXML:r22" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="urn:aseXML:r22 http://www.nemmco.com.au/aseXML/schemas ... ML_r22.xsd">
<Header>
<From description="NEMMCO">NEMMCO</From>
<To description="SPI Electricity Pty Ltd">EASTERN</To>
<MessageID>a4eca52a-1816-444a-be71-279664e30f92</MessageID>
<MessageDate>2009-07-20T15:13:49+10:00</MessageDate>
<TransactionGroup>CATS</TransactionGroup>
<Priority>Medium</Priority>
<SecurityContext>None</SecurityContext>
<Market>NEM</Market>
</Header>
<Transactions>
<Transaction transactionID="a4eca52a-1816-444a-be71-279664e30f92" transactionDate="2009-07-20T15:13:49+10:00">
<ReportResponse version="r10">
<ReportParameters xsi:type="ase:CATSSnapshotReportParameters">
<ReportName>Snapshot</ReportName>
<Participant>EASTERN</Participant>
<AsAtDateTime>2009-07-20T15:13:49+10:00</AsAtDateTime>
<Tables>
<Table>CATS_METER_REGISTER</Table>
</Tables>
<LastSequenceNumber>1</LastSequenceNumber>
</ReportParameters>
<ReportResults xsi:type="ase:ReplicationReportFormat">
<ReplicationBlock tableName="ElectricityNMIMeters">
<Row xsi:type="ase:ElectricityNMIMeterRow">
<SequenceNumber>14941778</SequenceNumber>
<CreationDate>2003-12-16T11:49:27+10:00</CreationDate>
<MaintenanceDate>9999-12-31T00:00:00+10:00</MaintenanceDate>
<RowStatus>A</RowStatus>
<FromDate>2003-12-15T00:00:00+10:00</FromDate>
<ToDate>9999-12-31T00:00:00+10:00</ToDate>
<NMI>2001152666</NMI>
<SerialNumber>728653</SerialNumber>
<NextScheduledReadDate>2009-09-02</NextScheduledReadDate>
<Location>60</Location>
<Hazard>1</Hazard>
<InstallationTypeCode>BASIC</InstallationTypeCode>
<Route>62051</Route>
<Manufacturer>Email</Manufacturer>
<Model>YA1625</Model>
<Constant>1</Constant>
<Status>C</Status>
</Row>
<Row xsi:type="ase:ElectricityNMIMeterRow">
<SequenceNumber>19609933</SequenceNumber>
<CreationDate>2004-09-23T02:15:46+10:00</CreationDate>
<MaintenanceDate>9999-12-31T00:00:00+10:00</MaintenanceDate>
<RowStatus>A</RowStatus>
<FromDate>2004-09-21T00:00:00+10:00</FromDate>
<ToDate>9999-12-31T00:00:00+10:00</ToDate>
<NMI>2001217326</NMI>
<SerialNumber>293563</SerialNumber>
<NextScheduledReadDate>2009-09-08</NextScheduledReadDate>
<Location>60</Location>
<Hazard>28</Hazard>
<InstallationTypeCode>BASIC</InstallationTypeCode>
<Route>65351</Route>
<Manufacturer>Landis & Gyr</Manufacturer>
<Model>YA1841_5</Model>
<Constant>1</Constant>
<Status>C</Status>
</Row>
</ReplicationBlock>
</ReportResults>
<Event severity="Information">
<Code>0</Code>
<Explanation>Success</Explanation>
</Event>
</ReportResponse>
</Transaction>
</Transactions>
</ase:aseXML>