DSXchange

But that is just for us in the northern hemisphere; Ray and Vince would need to work on stage right due to coriolis force.

Does that mean left joins go faster north of the equator as well?

Kris_r - become a premium member and you will see that message and many more - and also get more detailed responses to your queries.

Ray - as in "exeunt, stage left...."

Exporting is not what Ray recommended. Nor would I do so. The best way is to do a full project export, create your project on the new machine and import.

What is the error that you are getting?

You cannot just copy a DataStage Server or project directory from one machine to another. The installation directory needs to be reinstalled on the new machine. There are ways of getting an existing project directory from one machine to another at the OS level, but they do require that the path rema...

Craig - don't be so cruel...
Jagan222 - the answer depends on whether you mean Stage Left or Stage Right as viewed from the keyboard.

What kind of a stage is TGT_CL_ACC and does the error occur when only one job is run?

Hello Jagan, as you might have noticed, there isn't too much interest in this particular forum to answer interview questions in order to allow people to pass them - versus people asking questions regarding actual issues they are having with using the product. If you really wish to go about learning ...

I assume you mean migrating Server jobs from 5.2 to Server jobs at 7.5x on a machine that also has PX. Is this what you are asking?

I used to use job control extensively, but that was before sequences existed, now I think it is better for maintenance purposes to use a before/after routine and pass the parameters via one long dynamic array. DataStage is very, very efficient with strings so I wouldn't worry about the length.

Ray - not for a DECODE with only 4 values; that would be a lot of overhead. an IF-THEN-ELSE... construct or {my preference} a INDEX/LOCATE statement is going to be faster than a cached hash lookup. If there are tens or hundreds of lookups then that would be a different matter.

The "Ans = ..." lines are not used when called as part of job control. Can you write a 2-liner routine that defines and calls this before/after job one and see if you still get the same error. Also, the output of what caused the termination might be found in the &PH& log file for the run.

The CASE statement is used in multi-line programs while the IF-THEN-ELSE can be done on a single line (i.e. in a stage variable or derivation). The CASE in a BASIC program looks like BEGIN CASE CASE I=AmTired Ans = 'Goto Sleep' CASE Today='Tuesday' Ans = 'Only 3 days left to the weekend' CASE 1 Ans ...

I hope you don't mean the DEBUG statement in Basic programmer's guide. This statement is meant for programs associated with a terminal because it uses the interactive RAID debugging tool. You can use the DataStage job debugger from the designer to debug at a job level; if you wish to debug your prog...