DSXchange

Is the DataStage Developers group associated with a DataStage role? Were you actually successful in adding the user to the group?

Yes, you can expose your DataStage job as a web service. Search the forum for RTI (real time interface). This is probably a good approach in this case.

What type is the job parameter? String? Integer? Date? The error code -4 says that the value you've provided is not apporpriate for the parameter type. What value was provided? Check for line terminator characters in $CommandOutput - you may need to trim them.

An empty dynamic hashed file will have DATA.30 4KB in size and OVER.30 2KB in size. The first 2KB in each case is a header containing control information; the second 2KB in DATA.30 is the first group buffer. If you use MINIMUM.MODULUS then DATA.30 will be appropriately larger. If you use GROUP.SIZE ...

You only need to give 775 permission to dsenv file. Whatever you need to do in .profile to talk to Oracle you also need to do in dsenv file.

I seriously doubt that you will ever collect an Abort message in an after-job subroutine, since the job will have aborted before executing the after-job subroutine. You would need to do this in a Routine Activity in a job sequence.

Isn't this a good job for an Aggregator stage with some combination of Max or Last as the aggregate function?

Are you sure that the data are stored in this format, or is it only that they are being displayed in this format? What is your proof? It is very unusual to store data in a decimal exponential format. (There is an IEEE standard for storage of floating point numbers in a binary exponential format, but...

Only "=" works with the Hashed File stage. To use "<>", "BETWEEN" or any other operator you need an SQL-based stage serving the reference link. A UV stage would do it, or any database stage. But first ask yourself is this really what you want? It will return very many rows for every row processed on...

Oconv() is not available in parallel jobs. However you have case conversion functions available in the Modify stage and the Transformer stage. In your case, however, needing an "initial capitals" conversion, these choices are not easy (particularly O'Brien and the like). You can write your own expre...

Unfortunately the only detection in DataStage is the timeout when a job fails to start within a hard-coded interval. That is we can't tune the timeout. And, as you noted, the job that can not start aborts. You probably could do something with UNIX, but there's nothing supplied "out of the box" as fa...

It may, but you have to handle null explicitly and have the target column nullable.

Even better, the technique generalizes to parallel jobs. Using variables in COMMON does not.

Hello DaeHwan,

Your monitoring will show that each job uses more than 50% of a CPU if run separately. This tells you, by simple arithmetic, that 30 jobs on 16 CPUs is overloading the machine. This is why you must run fewer jobs at a time to overcome this problem.

I don't know where this is coming from? Certainly including a Transformer stage in a parallel job will require more time to compile, because source code has to be generated and compiled. And there will be a small overhead in initial invocation of any libraries needed at run time. But would not the s...