DSXchange

What does the execution sequence number do? If I understand you example correctly, the second case (execution sequence number 2) can never occur because the test on CUSTSEGMTCODE and ACCLASS is already satisfied in the first condition. In any case, build the expression as nested If..Then..Else with ...

srinivas.g wrote:I am trying to use the improved reject link operation

Whose improvement?
Is this something supplied with the product (in which case I need to study the manuals more thoroughly), or is it an improvement you have made/wish to make?

Fortunately it's easy to do in DataStage BASIC. Simply subtract 1 from the internal format date then apply a "DWA" conversion using Oconv().

None of which I am aware. Version 7.5 was Ascential, version 8.0 is IBM. The latter has its own standards.

They (IBM) produced an "errors manual" which does not live up to the hype. Fewer than 20% of the error messages are contained in it.

You may need to Force Compile to get the Transformer stages re-compiled.

There is a check box for this in the multi-job compiler, or you need to compile from the menu in Designer.

No.

Try disabling operator combination to see what the error really is and where it is being generated.

Trying to decode errors produced by APTCombinedOperatorController is a fool's errand.

When there are two inputs, Left and Right, the Join stage works as follows. Recall that the input are sorted on the join key. Get all the rows with the next key value from the Left input. (Usually this is not many rows.) Get all the rows with that key value from the Right input. (This can be as few ...

Auto will give Round Robin, which would have to be repartitioned for the Join stage. Set the partitioning appropriately for the Join stage (presumably hash on the join keys) on the input to the Transformer stage, so that re-partitioning does not have to occur.

It will NOT be the same error, and that is the point. Instead of APTCombinedOperatorController you will get the name of the actual stage in which the error is being generated. Please post THAT error message.

You can also use the command line interface dsjob to reset a job.

Did you attempt what I suggested?

Perhaps your request should be through your official support provider, rather than "some guy at IBM". Keep your support providers in the loop at all times, so that they remain aware of the issues at your site. Also, you are paying them to help you to identify and solve problems - let them ...

My guess is that you have an example of over-enthusiastic operator combination occurring. This will always be the case with operator combination - it is as aggressive as it can be under the rules for combining operators (the operators must be adjacent and share the same degree of parallelism on the ...

Output 0, Output 1 and Output 2 are the three output links from stage tfpCustIntlcl (in the output link execution order first, second and third), in much the same way that node #3 is the fourth node named in the configuration file - all numbering is zero-based. Your record counts indicate that 11713...

Show us what's in the container. In particular is there at least one Container Input or Container Output stage?