DSXchange

Hi Group, My job design is as follows JobActivity1 ----| JobActivity2-----|--->Sequencer--->Notification JobActivity3-----| Each of the Job Activities launch a job that read an input text file and loads into a target SQL Server Table. The underlying job is run as Multi-instance. The sequence is set ...

I concur with Gateleys. If you walk through the example in the first link, you will be able to get a solid foundation on using XML in Datastage. Depending on your database instance you might have to adjust accordingly. But the ideas are explained in detail. The second document has time-tested guidel...

I concur with Gateleys. If you walk through the example in the first link, you will be able to get a solid foundation on using XML in Datastage. Depending on your database instance you might have to adjust accordingly. But the ideas are explained in detail. The second document has time-tested guidel...

Hi HN Search will be the best way to go... You will find a lot of exhaustive topics on XML issues.... The following links are very popular in the community... http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0703xiong/ http://www.duke-consulting.com/Downloads/XmlPackBestPractices.zip...

After burning ourselves trying to read XML Input files that are > 500 MB using the XML Input stage, it would be good to have an option in the XML Input stage to specify what type of XML Parsing one wants to use - DOM, SAX et al. Right now, the XML Input stage uses DOM and loads up the entire XML fil...

Thank you Craig. I have submitted a request to the support group to check if they have any comments as well. I will post here when i hear something. I wonder how the XML Output stage would behave in such cases. Even if one were to chunk out the various fragments, at some point in time the XML Output...

Thanks Craig. I checked the box and it is SP1 with PAE enabled. I wanted to check with a few folks here before i did anything to the server. Of course, this is going to be a service request to the admins and with some details on why it is required - as it involves a reboot, i believe. Will update th...

Hi, I have a parallel job that reads an XML file via XML Input stage and copies the elements (according to XPaths) to a target database. This job works fine for small sized files (< 90 MB) with 1 million records. The real file that i would like to process is 520 MB and has about 4.4 million records....

Hi Group, At last got a patch from IBM Support for this issue. The ECase reference is E119230. The limitation at this time is that this patch only fixes the ODBC Enterprise stage. We had this issue when using the SQL Server enterprise stage and that is still not fixed and is addressed by a separate ...

Hi Craig,
You were correct.
The feedback from support was that the C++ Xerces is the backend parser and it cannot be swapped with a new version by sites. This has to be part of a patch from IBM.
Thanks for your time.

Cheers!!!

Hi,

How can we determine the version of the XML Parser used by Datastage?

Also, is it possible to configure Datastage to use a particular version of the parser, if the version that is found in an install is older that what might be available recently?

Thanks in advance for your time and input,

How does your XML structure look like? Do you have something that resembles the following? <?xml version="1.0" encoding="utf-8"?> <Employees> <Employee> <ID>1</ID> <Name>Name 1</Name> </Employee> <Employee> <ID>2</ID> <Name>Name21</Name> </Employee> </Employees> <Employees> <Empl...

Hi Group, Just to update you on the status of this question. After a few iterations with the IBM Support group, this is finally entered as a regression ECase as a feature working in a previous version 7.5.2 not working in the current version 8.0.1. The support team confirmed that they were able to r...

I had submitted this to the IBM Support group (long time ago) and received some feedback during the end of last week. It appears that the Engineering team was able to narrow this behavior to a path in their code where the client tools "lose/forget/" the working directory information. The d...

Ray & Group, I have some more updates on this issue. As I have been testing this in 8.0.1 all along, I decided to try this in 7.5.2 to see if it makes any difference. To my surprise, this works without any glitches in 7.5.2. To clarify, this job design works in all the following tests in a DS Ve...