DSXchange

Can I use KeyMgtGetNextValue DS routine in a parallel job.

If yes how?

I'm not able to see it inside a transform satge. trying derive using a DS routiune.

Hi, I'm trying to parsing XML document to tabular data, for that I'm using Folder stage --> XML Input --> Oracle Table. I'm getting a runtime error as below XML input document parsing failed. Reason: Xalan fatal error (publicId: , systemId: , line: 0, column: 0): An exception occurred! Type:RuntimeE...

chulett wrote:Use a Record Delimiter String as that DOS 'newline' is actually two characters. ...

could not get what you mean by two characters.

Do i need to put "\N"?

How I can have record delimiter as DOS newline character.

I'm extracting table data to a flat file and sequential file stage is my target.

I need to transform a XML file data into a flat file. 1st step I did is craeted XML table definition using XML metadata importer. Then I have taken a XML input stage and sequential file stage and loaded columns from table definition to XML input. what input I should give to XML input? I'm doing it o...

I have specified the select statement in properties

Thanks a lot for your replies. It got resolved now.

How I need to provide that

Thanks a lot. I'm alone here to work on datastage and I have used different ETL tool before.

I have imported the table and linked it to a sequential file. When I'm trying to compile it is throwing error "property select statement is required"

Hi,

I'm a new user, I need to put all the of a table to a flat file. Please help me in this. let me know which stage to use and which properties to be used. A detailed description is required. It would be great If any one can help me with a training material which describes how to do it.

How I can verify that Fix pack 1 is installed in my system. I 'm using Datastage designer 8.5 client.

I need to use XML stage where as XML stage is not present under Real time palette.
My administrator told that He has installed Fixpack 1.

Please advice.

Thanks everyone for your answers, It helped me in a great deal. I got the colclusion now that If I need to use XML stage then I Have to get Fix pack 1 and I need to use only Parallel jobs. still I have below questions 1. Which is better XML pack(XML input,XML output,XML transformation) or XML stage....

All of our Custom OTM (Oracle Transportation Management) interfaces and few other Interfaces use XML files from OTM and need to load into JDE Staging tables or EDI tables for Edge EDI transmissions. So we are looking for XML Graphical parsing capabilities without having to do much of programming. We...

Do I need to install any add on or patch to get XML stage in Datastage 8.5?
I'm new to DS world and novice user. please explain in detail. My requirement is to parse a XML and convert it to CSV.