DSXchange

Aramachandra, PX jobs start a lot of UNIX processes, each does a portion of the work. The jobs communicate with each using pipes. Each pipe has a writer and a reader, if one of the two unexpectedly terminates the connection (a close or the job aborts) then the other will report a "broken pipe". Sadl...

I've had trouble getting the sequential file definitions set up correctly in PX, it takes a lot more work than in server. The error messages tend to be more verbose than yours, though. It sounds like you have a NLS installation and a mapping is failing. Does this file contain NLS? Just to make the d...

Doesn't the MKS Toolkit get installed as well as part of DS 7.5x on Windows? If that is the case, you can use the UNIX command "fuser" on the file to see if any other process has it open. I don't think that the DOS cmd shell has a similar command, so installing MKS toolkit on the DataStage server mi...

Plus you need to disable the write cache option when writing to the file so that updates are immediate.

Hello Lucky, the hardware requirements for DataStage are not a fixed value and depend very heavily upon the expected usage. The minimum to install is the disk space requirements of the server. DataStage itself reserves some shared memory segments and starts at least one background process (that is t...

Kollurianu,

the first sounds like a user-written routine, the second is a DataStage routine which, when I tried using the search function, has been referenced 11 times already.

Maffan, in the past I've done a couple of TELCO projects and when I have had to do this I've used a branching decision tree structure. Due to the mechanism used with variable lengths you will not be able to make this into a single condition. I also found that it makes more sense to order the if-then...

The old instances should be gone. I would recommend to stop the DataStage server and then kill the old process manually before re-starting. Is this problem repeatable after a coldstart of the actual Windows box?

Hemant, if you were to approach this problem step-by-step it would be easier for you solve and find the problem. Change your job to do simple derivations in output columns and write those to a sequential file. The conversion as you have listed will not work, if you break it into simple components yo...

Winky man worked for me - took me directly to the appropriate page.

INDEX(MyString,'$',1) returns the position of the first $ in the string. But in your case I might use: PercentageValue = FIELD(In.StringVar,'%',1) DollarValue = FIELD(In.StringVar,'$',2) This treats the % and $ signs as if they were field separators and, to use the example of '%', it parses the stri...

An had I been on a German keyboard it would have been "az 7.x"

When it comes to obvious errors in the product, I agree wholeheartedly with Kim. Sometimes it makes sense to post questions here in order to confirm that this is actually a problem with the product and not in how DataStage is being used, but my issue is that so many of the posts contain very little ...

Apraman,

what Ray and I are subtly trying to point out to you is that a sequential file can only be written to by one process; so the partitioning information you are asking for is irrelevant.

No, it will work ay 7.x