DSXchange

Did you do what I asked you to do in my very first reply?

In the OPEN command of your target database stage, pass the truncate command and use regular LOAD method. Is that what your asking or am I missing something here?

How much the cpu is utilized and what process utilizes what cpu is controlled by the kernel. It is not possible to control that at this high level of programming.

Your time format is not correct. Put the following in the format mask

See if this post helps.

Have a second link going from your transformer to any stage, say a peek stage, with the constraint set to varFlag = 1. In the properties for this link, set Abort after 1 row. This way when your stage variable condition is 1, the record will go down the second link and it will raise an abort.

You need to set the environment before the dsjob can be recognized by the kernal. Perform the following

Once you have done that, now try the dsjob command.

Is your problem a reproduceable error? Did you try running it again? Maybe your system was overwhelmed at the time and hence your error. Refer to this post for more clarification.

Enterprise Edition has its own set of transform functions. Some of them are the same as Server edition. Never the less, they are different for both the animals. If you absolutely have to use a server transform function in a parallel job, then you could either code the same logic in a C function and ...

Thats an excellent history portrayed by Vincent. Thankyou Vincent.

True. That might be the case in the long run. But this was a short term, relatively small amounts of data and hence was an acceptable workaround. You should try a test. Send in a large integer, thats larger than the integer range, into a BIGINT column, but mask it as integer or numeric in datastage....

I had this problem a couple of years ago. I just changed the datatype within my job to integer as a workaround.

Why in the world are you trying to execute ./.uvconfig?
What commands are you running. If you following my commands, exactly and your still getting an issue then something is wrong at your end. Can you get into the dshome directory? Do you have read/execute permission on dsenv?

Only with a basic transformer, not with px transformer.

Exactly my point. All these validty checks and incrementions need to be handled in a structered piece of code. Go for a routine.