Reading xml files
Posted: Mon Jun 15, 2009 12:45 pm
Hello
I have an xml file as follows:
<?xml version="1.0"?><QuantumViewResponse><Response><TransactionReference><CustomerContext>Test XML</CustomerContext><XpciVersion>1.0007</XpciVersion></TransactionReference><ResponseStatusCode>1</ResponseStatusCode><ResponseStatusDescription>Success</ResponseStatusDescription><Error><ErrorSeverity>Warning</ErrorSeverity><ErrorCode>336000</ErrorCode><ErrorDescription>The follow</ErrorDescription></Error></Response><QuantumViewEvents><SubscriberID>kschrank</SubscriberID></QuantumViewEvents></QuantumViewResponse>
The parallel job has been defined as seq file ----->xml input stage ----> peek stage. The seq file stage Output/Properties tab/Read method = specific File. Format/Record level/RecordType = implicit, Format/Field Defaults/delimiter=none, columns = single column sqltype = longnvarchar and length 9999.
When I "view data" I see 2 rows. However, if I reduce the length of the xmlfile input to less than 512 characters, I see one row.
This is just a test. In reality, I will be reading an xml file that maybe as long as 15000 characters. What am I doing wrong?
Thanks
I have an xml file as follows:
<?xml version="1.0"?><QuantumViewResponse><Response><TransactionReference><CustomerContext>Test XML</CustomerContext><XpciVersion>1.0007</XpciVersion></TransactionReference><ResponseStatusCode>1</ResponseStatusCode><ResponseStatusDescription>Success</ResponseStatusDescription><Error><ErrorSeverity>Warning</ErrorSeverity><ErrorCode>336000</ErrorCode><ErrorDescription>The follow</ErrorDescription></Error></Response><QuantumViewEvents><SubscriberID>kschrank</SubscriberID></QuantumViewEvents></QuantumViewResponse>
The parallel job has been defined as seq file ----->xml input stage ----> peek stage. The seq file stage Output/Properties tab/Read method = specific File. Format/Record level/RecordType = implicit, Format/Field Defaults/delimiter=none, columns = single column sqltype = longnvarchar and length 9999.
When I "view data" I see 2 rows. However, if I reduce the length of the xmlfile input to less than 512 characters, I see one row.
This is just a test. In reality, I will be reading an xml file that maybe as long as 15000 characters. What am I doing wrong?
Thanks