DSXchange

I have a xml file that needs to be loaded into a seq file for further transformations. I'm unable to get any output from the XML Input stage.

My first stage is a sequential file stage where I have specified a column name "Input" as LongVarChar. This is followed by a XML Input stage and a target Sequential file.

In the input tab of the XML Input stage, I choose the following-
XML source column = "Input"
Column content = XML document

In the output tab of XML Input stage, I choose one o/p column as a repetition element.

I also gave a reject link to the XML Input stage. When I run this job, no rows are loaded into the target sequential file and many rows are rejected. When I try to view the data in the reject file, it shows the following error -
XML input document parsing failed. XML input document parsing failed. Reason: Xalan fatal error (publicId: , systemId: , line: 1, column: 6): There are more end tags than start tags

Please help.

On the DataStage distribution CD there are xml-sample, install them and make similar jobs. That is a good first step and a great help.

I dont have the installaiton CD as i'm working on client machine through a remote connection.

So your client has the CD. Get them to make the samples available. That way no-one violates their license agreement.

Thats the only way to read xml file

Give me some other solution its(cd installtion) a very big process

Your first stage should be a Folder stage, not the Sequential. How did you generate the metadata you are using for the XPath Expressions in the XML stage?

ok as u said I used folder stage but I am facing new problem
I have used a XML input stage to extract data from a XML file to a sequential file. In th XML input stage, I have the option of providing only a single repetition key.

How can I provide multiple repetition keys in the XML input stage as I have more than 1 primary key in the XML file?

Please help.

You can't.