DSXchange

Passive stages that have input and output link (apart from reject handling) are specifically prohibited in parallel jobs.

rumu wrote:....may be for the reason that I am not a premiere member....

That, at least, is easily fixed.

You can still switch between them using Director.

11 isn't aborted - it is "validation succeeded". Similarly 12 should go to Warnings.

Welcome aboard. Same answer as above.

You can also take training classes, from IBM or elsewhere.

Why don't YOU think it through? You have a good idea what you need to do, I've suggested something to try (which it seems that you haven't), and you ask for other ideas?

You're wrong.

Everything that is supported in version 5.2 is supported in version 7.5.2, and more.

You may be confused by the fact that Hashed File stage does not exist in parallel jobs. But server jobs continue to be supported in 7.5.2, 8.0 and beyond.

ODBC

Server job (as posted) or parallel job (as marked)?

WHAT compilation errors is it giving? Or do you expect us to guess?

Click the Search link in my previous post.

My car is not working. Can you help me out? This kind of question is impossible to answer. We have no idea at all of the data you are processing, the expected output, the actual output, what your job design is set up to do, the precise version of DataStage, nor what error or warning messages are app...

Install 7.5.2.

Export projects from 5.2. Verify (import into 5.2 without actually importing anything).

Create corresponding projects in 7.5.2.

Import into 7.5.2 projects.

Re-compile jobs and routines on 7.5.2 just in case (use Multi-Job Compile tool).

Done.

Two consecutive jobs.

Only your Oracle DBA can sort it out (which is what I suppose you meant). Nothing, not even DataStage (which is just another client application as far as Oracle is concerned) can bypass database privileges. You can Search DSXchange to find out why SELECT privilege is required to certain Oracle syste...

Compare the trimmed strings. If that alone doesn't work is the Compare() function available? (I'm not on site right now.)