DSXchange

Do you claim that this occurs in every job, at the same line number?? Is your design DRS ---> Transformer ---> HashedFile or is it more complex than that? Please describe everything that you do in the Transformer stage: stage variable initialization expressions, stage variable derivation expressions...

If we use DB2 EE stage to extract the attributes, is it improve the perforamnce ? How about you test it and you tell us? In theory, because the Enterprise stage can work in parallel, it ought to give better throughput, but your SQL may result in sequential operation - for example if it includes GRO...

Not possible. You can certainly set an environment variable in a stage variable, but other stages are almost certain to run in other processes and therefore get their own environment. How do you propose to get the environment variable in the "other stage" and what kind of stage is it? You may prefer...

The main one is that you won't get support. There is no version of DS 7.5 EE that is supported on / certified for Windows 2000. The only 7.5 EE release is 7.5x2, and it's only certified for Windows 2003. Other than that, it may work, it may not. There's only one way to find out. Clearly some aspects...

The original problem seems to relate to the SeqFile variable in the ReadU statement. (Unrelated question: why use this name for a hashed file? It only confuses future developers.) For some reason there is a path through your code where SeqFile does not get a value (or Initialized has a non-zero valu...

You're lucky it's after the 9th of the month and after September, so you're automatically getting two-digits in the month and day. You need to force two digits as follows:

It shouldn't have worked. Can you post the text of the script? This will help us to understand what you did.

Any COM object should expose its methods to anything that calls it. All you need is to figure out how. The dsobjects.dll is not well documented, though most of the objects are described fairly well in a UniVerse manual called UniObjects Developers Guide which you can download from IBM's web site. Th...

You can't reliably use any routine that uses variables in COMMON (see the end of Chapter 2 of Parallel Job Developer's Guide for proof). This particular routine does use COMMON, so is not appropriate for use in a parallel job.

Not to mention flooding the machine with processes!

Possibly. What do you mean by "checking"?

ALL of them. It's a non-trivial exercise to learn them all. I've been doing so for more than 20 years. There are no short-cuts - you need 20 years to get 20 years worth of experience. But don't worry about it - it's almost impossible to invoke UniVerse commands from parallel jobs, and you've posted ...

QualityStage currently can work independently of DataStage (processing files), or it can be invoked via a plug-in stage in which rows are passed to and fro along links as with any other DataStage stage. In the next (Hawk) release QualityStage per se ceases to exist and there is a combined Designer f...

Alas, I don't know whether they have a fix. Have you formally reported this problem via your support provider?

Yes, provided that the date column is not declared to be NOT NULL.