DSXchange

Try running in a single-node configuration - does it work? If yes, you might be running out of resources. Are you loading lookup files in this job?

If you put your routine call into a stage variable, make sure that the stage variable derivation is empty and you put the call into the intial value part; that way it is only executed one time per job run, not once per row of data.

At the moment you need to do a query such as what Anupam has given in the Admin tool or by using TCL or by writing your own routine/job; fortunately with HAWK they have built this search into the client!

I'm not at a DataStage client right now so cannot check up, but I thought either setting APT_DUMP_SCORE or another debugging switch will display not only how many processes are used in running a job but also which PIDs they have. You can also traceback the PID to its parent and so on until you get t...

There is no simple method to do this. If you start off with a DUMP_SCORE value you will see how the compiler has put the runtime objects together; you will see how many actual processes are fired off and which stages have been "combined" out of the executable. Then you will have to look at each stag...

All you need to do in order to create a multiple instance DataStage job is to check on the tick box in the attributes of a job in the Designer. You will need to make sure that this job can run in parallel by yourself - for instance by checking to see that any output or interim sequential files have ...

You could do it from UNIX using "dsjob -lsum -type WARNING" or with a routine in DataStage using the DSGet... routines. It depends upon where you prefer to do the work.

Ahh, I see what you are trying to do; I thought you had misplaced the FIELD() parameters. Unfortunately the delimiter for both forms needs to be a single character, so this won't work.

You are right, in 99% of the cases this is unnecessary as the implicit padding will be right when going to a VarChar from CHAR. But sometimes the default pad character might not be set to space - so in this type of scenario I'd always opt for the explicit method. I am thinking more of PX jobs than s...

The purchased decompiler (can't recall who sells it anymore) will retrieve everything but common block variable names and CASE constructs (they compile down to embedded IF-THEN-ELSE statements. But you would still need to take those programs and put them back into the repository. This can be done fo...

The delay is because of all the warnings and of course your data isn't being loaded either. Fix your data and the job will run much faster.

sudhakar_viswa, I had to answer that way to your question and would do the same next time. Of course we understand that the problem is urgent for you, not for anyone else. But I felt that since it wasn't urgent or important enough for you to use the SEARCH facility I wouldn't expend any energy on th...

Anupam - what does the subfunction

InLink.Field["001",1,1]

do? This is not a legal substring expression.

You are going from CHAR(1) to CHAR(2). Use explicit padding of one space in your derivation. The derivation for TrgCol1 is

The ASAP answer is : yes.