Loading XML file data into a Seq. file

bachi · Post by **bachi** » Mon Sep 15, 2008 2:19 am

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.

WoMaWil · Post by **WoMaWil** » Mon Sep 15, 2008 3:23 am

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.

bachi · Post by **bachi** » Mon Sep 15, 2008 3:59 am

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

ray.wurlod · Post by **ray.wurlod** » Mon Sep 15, 2008 4:28 am

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

bachi · Post by **bachi** » Mon Sep 15, 2008 4:51 am

Thats the only way to read xml file

bachi · Post by **bachi** » Mon Sep 15, 2008 4:57 am

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

chulett · Post by **chulett** » Mon Sep 15, 2008 7:22 am

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?

bachi · Post by **bachi** » Thu Sep 18, 2008 3:23 am

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.

chulett · Post by **chulett** » Thu Sep 18, 2008 7:48 am

You can't.

DSXchange

Loading XML file data into a Seq. file

Loading XML file data into a Seq. file

How to provide 2 or more Repetition Keys in XML input stage?