DSXchange

Somewhere on the planet other than in the USA. Cost would depend on a number of factors (including travel cost to location, whether you will supply hardware, DataStage). Send request for quotation with specific details.

If you want one outside the USA, and can guarantee a minimum of six attendees, then maybe I can assist. Contact me through this thread or off-line if you're interested.

Post on the correct forum (server or parallel).

This forum is for posts about the DSXchange itself.

Castigation Notes One question per thread please. It makes it easier for future searchers. For the same reason please try to use a meaningful subject. Please get the details right. APT_DISABLE_COMBINATION is an environment variable, not an operator, and its name is given in all upper case. Properly...

You have not given us sufficient information. What is "it"? What is the job design for the first question? Disabling operator combination alone should not make any difference to null handling - you would have to look at the score to determine precisely what was being executed. ulimit -f sets the max...

Then please mark the thread as Resolved and post a note indicating precisely how you solved it, so as to help future searchers after answers.

You can not, if you are using EVAL, suppress the EVAL message. EVAL expressions must be compiled, and the compiler reports its output. There is no way to disable this. However, you're trying to cheat on us. The output you give is not from the query you give; the query you give does not have any EVAL...

No. This is an IBM training class. The only way you can get your hands on a copy is by taking the class, or through PartnerWorld if you are an IBM Business Partner certified to present the class in question.

I didn't know there even was a version 7.2. Orchestrate manuals come for version 7 (meaning 7.0) and 7.5. The latter is better, as it contains fewer errors. Almost everything in it will work OK with DataStage version 7.0 through 8.1.

There are rules about commas in data in comma-delimiited files. You can read about them in any product (such as Excel) that generates them. What you have is not a legally-formatted comma-delimited-format file.

The best is (Auto) in general. For a large reference table into a Lookup stage you may get some benefit from hash partitioning both the stream and the reference input based upon the lookup key. Any stage that requires key adjacency (the previous poster mentioned some of them) requires partitioning o...

Orchestrate Operators manual. The Orchestrate manuals are available for free from your support provider (they may know them as the DataStage OEM manuals). Ask for the version 7.5 manuals.

We can never help anyone reporting exceptions, errors or warnings from APT_CombinedOperatorController.

Disable operator combination and re-run. The error message will now come from some explicit operator in the job design, which is far more amenable to diagnosis.

Could you please indemnify against severe prosection by IBM's copyright and intellectual property police?

Bring NLS_LANG into the project as an environment variable (you do this in the Administrator). Then you can use it in DataStage jobs as a job parameter and set it appropriately for each indivvidual job. The same is true for any other environment variable that may apply, such as LANG_C.