DSXchange

chulett wrote:So, what is your 'workaround'?

I am facing the same issue, Any ideas about the work around/Fix?

Could be a lot of things......Some initial suggestions would be .....Check your filenames, check your security rights, test with other xml documents, try using a Server Job instead to "get to know" xml Pack (use the Folder Stage in a Server Job [take a look at the xml entries in my blog b...

Dear Ernie, Thanks for your reply. I was not entirely sure what you meant in your post being new to datastage. I have spoken to IBM and they have shared me the following solution which I think may be exactly what you were explaining. Step1: Create a job parameter of type pathname with the location ...

Dear Ernie, Thanks for your reply. I was not entirely sure what you meant in your post being new to datastage. I have spoken to IBM and they have shared me the following solution which I think may be exactly what you were explaining. Step1: Create a job parameter of type pathname with the location ...

times29 wrote:Hi,
How can i see how may rows each node is processing.

Thanks

You can get that information from Job Monitor in the Director. Right click on the job and click Monitor. It will give you the number of rows each partition is processing.

Thank you Ernie and Craig for the help. I was aware of the multiple files I need to create from the XML. I am sorry If I have misled you with my test ETL, this is the first time I am working on parsing an XML. Ernie, Just to make sure that I understood this correctly, For each node there will be a d...

Interesting. If you check the document outside of DataStage, is it valid / well formed? Yea, I used cooktop to check if the file is valid and it the document is valid. Is the version of the file you are processing in the job the same as what you posted, i.e. the 'pretty printed' version from XMLSpy...

Can you post a representative snippet of the actual XML and your corresponding XPath Expressions? That would help a lot. When you do, let us know which you've marked as the repetition element. I tried one more thing, I checked the Log reject errors box in the XML Input stage in my ETL and ran it. I...

Can you post a representative snippet of the actual XML and your corresponding XPath Expressions? That would help a lot. When you do, let us know which you've marked as the repetition element. Here is the XML I am trying to process <?xml version="1.0" encoding="UTF-8"?> <!-- edi...

Typically this is an XPath Expressions issue where they don't match the source properly. Can you post some of the gory details of what you are doing, please? I got the XPath expressions from XML meta data importer. One thing I observed is some of the XPath expressions have @id or @class at the end ...

Hi, I have an xml file and I trying to process it by reading it as a sequential file and send it to a XML input stage and from there to the target sequential file. The XML input stage is taking in the records but not sending out any. The job successfully finishes without errors or warnings. Show per...

You appear to be running the job in reset mode from Tivoli. Is this the case? In that case I would expect the job status code to be 21. What version of DataStage (precisely) are you running? There were some issues in version 7.0.x with the wrong byte of the return code being passed back. Is there a...

I think this is more of a parallel concepts question. What is the need for Sort keys and Partition keys to be same? Do they need to be same at all? I have 10 columns in a data file and I want to sort the data based on just 5 columns, In the sort stage, can I just use one column to partition? Or Do I...

Hi, I am facing a strange problem with DS_AUDIT. I ran the following query in the Admin command prompt. SELECT INSTANCE, DTM, MODIFIER, REASON FROM DS_AUDIT WHERE CLASS = '2' AND INSTANCE = '<<Job name>>' It gave me the results but for MODIFIER all the jobs have same user id. I thought may be all th...

:?: PuTTY is a telnet client. What's your difference between "compile through PuTTY" and "compile through telnet"? Most "not found" error messages relate to a problem with one of the search list environment variables, in your case probably PATH. In turn this suggests t...