DSXchange

Also check how many rows are actually selected from your ODBC source, and verify the SQL SELECT statement being used. Does it, for example, contain an unwanted DISTINCT keyword?

No, because that would set a precedent to undermine one of the sources of revenue by which DSXchange hosting and bandwidth costs are funded. A premium membership, which will allow you to read the entire post, is not expensive, at less than 30c (Rs12) per day.

The Parameters field does not take expressions, only values.

Use

What is the key of the hashed file? If you have only 16 different (distinct) values for the key column then the hashed file will contain precisely 16 rows.

*Topic Relocated - Content Editor*

Welcome aboard. Please post the exact error message - it may even give you some clue if you read it carefully. The representation of NULL in the file must have the same number of characters as the field width. Therefore "X" is invalid as a representation of NULL unless the data type is Cha...

The given job design uses Data Sets as targets. Please don't introduce "red herrings". You can use a sort/merge collector if you need a sequential file to preserve sorting; it is not necessary to force the Sort stage to execute in sequential mode.

Welcome aboard. It is, in my opinion a Bad Idea to force a DataStage job to abort, but it is possible. You can create an extra output from the Transformer stage, and set its "abort after rows" value to 1, and send any row that is needed to cause an abort along this link. You can use a befo...

You use a text editor and some knowledge of Perl scripting. However, what precisely is it that you are trying to do? Write this down in English and turn it into a specification, and you may well find that your task becomes much more straightforward to solve. For example, is the DataStage job the web...

No, there's nothing there that explains that it's something you've done or anything in the matching process itself. I'm afraid you're going to have to engage your official support provider on this one. How large are the data sets you're processing?

That would certainly cause a problem, though I hope a more meaningful error message. Disable operator combination by setting APT_DISABLE_COMBINATION to True (maybe load this environment variable as a job parameter). You can also disable the combinability of any particular stage via its Advanced prop...

In process and Inter process are mutually exclusive. Inter process can only be used in SMP parallel systems. That bit is wrong. Provided a single CPU machine can support multiple processes (and they all can, these days), inter-process row buffering may be used. All IBM training classes that use int...

You could use a Wait For File activity that waits for a file that will never appear and which has a timeout set.

Before/after job subroutines in parallel jobs are written in DataStage BASIC. Routines callable from parallel Transformer stage must be written in C++ and compiled and linked, and have an entry in the Routines part of the Repository (a parallel "routine" is actually a description of the lo...

Just curious: would you mind asking said team member WHY the decision was made to use 60 as the new PAKTIME value?