XML Input Stage
Posted: Wed Jun 13, 2007 3:43 am
job : <seq file> -->> <XML Input> -->> <ora table>
im facing problems in parsing a XML document. below is a sample xml document:
<sdnEntry>
<uid>737</uid>
<lastName>EMPRESA CUBANA DE AVIACION</lastName>
<sdnType>Entity</sdnType>
<programList>
<program>CUBA</program>
</programList>
</sdnEntry>
the error I get is ''Xalan fatal error (publicId: , systemId: , line: 1, column: 1): Invalid document structure''
and there are zero number of rows output.
but if i remove the newline characters in the xml document ( like) :
<sdnEntry><uid>737</uid><lastName>EMPRESA CUBANA DEVIACION</lastName><sdnType>Entity</sdnType><programList><program>CUBA</program></programList></sdnEntry>
then the document is successfully parsed and i get the respective rows in the output.
Im suspecting it has to do with some settings in the Format tab page of the sequential file... any help in this regard would be helpful.
Also can anyone tell me how to use a schema file to validate the input XML document ???
many thanks
harshada
im facing problems in parsing a XML document. below is a sample xml document:
<sdnEntry>
<uid>737</uid>
<lastName>EMPRESA CUBANA DE AVIACION</lastName>
<sdnType>Entity</sdnType>
<programList>
<program>CUBA</program>
</programList>
</sdnEntry>
the error I get is ''Xalan fatal error (publicId: , systemId: , line: 1, column: 1): Invalid document structure''
and there are zero number of rows output.
but if i remove the newline characters in the xml document ( like) :
<sdnEntry><uid>737</uid><lastName>EMPRESA CUBANA DEVIACION</lastName><sdnType>Entity</sdnType><programList><program>CUBA</program></programList></sdnEntry>
then the document is successfully parsed and i get the respective rows in the output.
Im suspecting it has to do with some settings in the Format tab page of the sequential file... any help in this regard would be helpful.
Also can anyone tell me how to use a schema file to validate the input XML document ???
many thanks
harshada