DSXchange

There's not much to trace in "unable to attach to project".

Check that the project name is correctly spelled and cased. Check that the project still actually exists. Check that the authentication details are all correct.

If that's all you need, why did you buy licences for all the others? Some smooth-talking IBM salesperson, maybe?

No real idea, other than it appears to have occurred during composing of the score. Involve your official support provider on this one.

Were any other warnings or errors logged?

NO, because there is only one join type property, therefore you'll get L1 left outer join L2 left outer join L3.

To get (L1 inner join L2) left outer join L3 you'll need two cascaded Join stages.

Ordered (or Sort Merge) simply preserves sorted order as rows are retrieved from partitions. It is not a new sort.

Certainly an unordered collector is likely to be faster, but probably not by a sufficiently great margin to worry about until you are trying to tweak the last 1% of performance.

Not really sure. All I can suggest is to double check your data store information, particularly that for the IADB.

QualityStage does not "correct" anything. However, if there exists another record with the same address, then probablilistic matching can take the spelling/transposition errors into account when matching them to identify potential duplicates. Address verification (for example CASS, or what...

"Needed" is really up to YOUR needs.
The eight things you listed are all optional. But it would be odd not to install at least one of them.

The original formulation, provided that all five expressions are well formed, is perfectly valid. Validate expression, which Craig advised you to use, would have told you which of the five expressions was not well formed. Or at least the first of them that was not well formed. Lather, rinse and repe...

Did you specify AGY_ST as a sort key when specifying Sort Merge as the collector type? Try switching to (Auto) as the collector - DB2 does not need sorted input.

There is a DVD available from DSXchange Learning Center entitled Programming with DataStage BASIC which sounds like exactly what you want/need. Much of this training relates to creation of server routines of both kinds (transform function and before/after subroutine).

Is it still slow if you take Oracle out of the picture, perhaps replacing the Oracle stage with a Copy stage for the purposes of testing?

1. Please try to be more thoughtful in your choice of subject, so as to assist future searchers. 2. DataStage PX does not exist, indeed it never really did. It was just a marketing term. 3. Please strive for a professional standard of written English on DSXchange, so as to assist those whose first l...

1. Please try to be more thoughtful in your choice of subject, so as to assist future searchers. 2. DataStage PX does not exist, indeed it never really did. It was just a marketing term. 3. Please strive for a professional standard of written English on DSXchange, so as to assist those whose first l...

Place the entire command, with command line arguments, in the Input Values field. Any parameter references given here will be resolved before the command is passed to the shell. For example ls -1 #SourceDir#