DSXchange

No such thing as an Oracle 'long varchar', what is it actually - a CLOB?

Well then, with that out of the way I'll step aside in deference to people with actual 8.x PX experience.

Have you tried searching the pdf documentation for 'julian'? That's where I would start in your shoes.

Is the Express compiler listed as one of the supported versions?

They are stored in the DSParams file in each Project. A seach of the forums for that keyword will turn up several posts discussing how to migrate them from one Project to another.

Oyyy indeed.

However, just trying to answer the asked question.

It appears that there is a shift of the data from one column to another towards the end of this column list, i.e. that these are position based rather than name-based, so the entire hash file's metadata is changed by this second process. Yes, exactly, positional - but you can override the default p...

Ray is correct, of course, about the hashed file supporting simultaneous writers. I should have pointed that out as well. Sounds like your Oracle query(s) could use some tunage. When we have slow performance with large volumes it is usually a result of the optimizer deciding it needs nested loops in...

Perhaps you should post your routine? Or at least the portion that illustrates how you are doing the actual record retrieval.

[sigh] Saying "the run is bad" isn't any more helpful. Suggestion: stop focusing on this "delete the executable" topic. Take a step back and explain in detail what the heck "the run is bad" means. What is different about the environment where you are having problems? You do yourself a great disservi...

Tough one. Does it work for everyone else? If so, first suggestion would be to reinstall your Client.

Use one stage with 15 links, not 15 stages. Yes, all sessions will 'open' when the job starts but they will execute in order, one after the other.

And?

As Wolfgang noted, looking at the existing routines via the Manager is a good place to start. Double-click to see their source code.

I was able to find the information you are looking for by doing something as simple as a Google search for "What's new in DataStage 7.5". Unsurprisingly, Vincent has blogged on the subject.