DSXchange

Now, that's certainly strange. Is that also when you use our little 3 column example above with col1, col2 and col3?

Ernie

You need to first do all your transformation in transformer with all the XML path description in the output columns of transformer(manually) then input that to XML stage and select a "Single row" option in transformation settings. Now put just one column with a big varchar length in XML output tab. Now everything will be in one row one column, use a transformer again and in output description provide '\' in description and dump in sequential file. Now your output sequential file will contain each XML document in one line. I did this long time back but using server jobs and I believe it would me similar for PX.

how to validate the xml schema definitions in datastage.

I mean i got the xsd which includes other xsds in it. out side the datastage box if you save all these xsds in one place and if you validate the main xsd which holds other xsd will be validated.

Where as in Datastage how can we validate these xsd which include other xsd (which refer other xsd) in an xsd.

Thanks in advance for your suggestions.

New question = new post, please. This has nothing to do with "XML Single Line".