XML Input stage
Moderators: chulett, rschirm, roy
XML Input stage
Hi Team,
I am trying to read an xml file using XML input stage.
My job design is
Job design:
External source-->XML_Input--->SEq file
Settings:
External source:
==========
Properties:
source Method: Specific program(s)
Source program: ls C:\EMP_FILE_Job_Details.xml
Format:
Record type :Implicit
Delimiter:None
Columns:
Defined one column 'Filename' of VarChar type, Non-Nullable and din't specified the length
But I am getting the below error can any one suggest me please
XML_Input_22,0: Fatal Error: Fatal: XML input document parsing failed. Reason: Xalan fatal error (publicId: , systemId: , line: 0, column: 0): An exception occurred! Type:RuntimeException, Message:The primary document entity could not be opened. Id=C:/EMP_FILE_Job_Details.xml
Xalan fatal error (publicId: , systemId: , line: 0, column: 0): An exception occurred! Type:RuntimeException, Message:The primary document entity could not be opened. Id=C:/EMP_FILE_Job_Details.xml
I am trying to read an xml file using XML input stage.
My job design is
Job design:
External source-->XML_Input--->SEq file
Settings:
External source:
==========
Properties:
source Method: Specific program(s)
Source program: ls C:\EMP_FILE_Job_Details.xml
Format:
Record type :Implicit
Delimiter:None
Columns:
Defined one column 'Filename' of VarChar type, Non-Nullable and din't specified the length
But I am getting the below error can any one suggest me please
XML_Input_22,0: Fatal Error: Fatal: XML input document parsing failed. Reason: Xalan fatal error (publicId: , systemId: , line: 0, column: 0): An exception occurred! Type:RuntimeException, Message:The primary document entity could not be opened. Id=C:/EMP_FILE_Job_Details.xml
Xalan fatal error (publicId: , systemId: , line: 0, column: 0): An exception occurred! Type:RuntimeException, Message:The primary document entity could not be opened. Id=C:/EMP_FILE_Job_Details.xml
-
- Participant
- Posts: 437
- Joined: Fri Oct 15, 2004 6:13 am
- Location: Pune, India
search the forum and also go here:
http://dsrealtime.wordpress.com/2007/12 ... -a-source/
Don't use the Sequential Stage to read your xml documents.
Ernie
http://dsrealtime.wordpress.com/2007/12 ... -a-source/
Don't use the Sequential Stage to read your xml documents.
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
sorry...read that too quickly. haven't had my coffee this morning. Check your security for that sub-directory and also look at the encoding. I had a strange one like this recently and when I removed the entire encoding attribute (where it has UTF-8 or similar), it worked.
Ernie
Ernie
Ernie Ostic
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
blogit!
<a href="https://dsrealtime.wordpress.com/2015/0 ... ere/">Open IGC is Here!</a>
Hi
Thanks that resolved my problem in accessing xml file but now I am not able to read more than 1 file in a single run.
I have selected the option in external source is
Source Method = Specific programs
Source program= ls E:\ EMP*.xml
I want to read all the xml files that start with EMP in a single run, Can anyone help me if this is possible
Thanks that resolved my problem in accessing xml file but now I am not able to read more than 1 file in a single run.
I have selected the option in external source is
Source Method = Specific programs
Source program= ls E:\ EMP*.xml
I want to read all the xml files that start with EMP in a single run, Can anyone help me if this is possible
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The second person personal pronoun in English is spelled "you", not "u".NL wrote:How did u able to resolve this problem.I am also facing the same issue, plz help me out.
There is no word "plz" in English - I suspect you mean "please".
Please strive for a professional standard of written English on DSXchange.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.