DSXchange

What volume of data?

There is a third possibility (maybe more), to use a Transformer instead of Link Partitioner, with different constraints and derivations on each output.

Sounds like a bug. Unsigned integers are sometimes reported as negative numbers, but never in the range about which you are talking. What did your support provider suggest?

Note that the BASIC Transformer (or server shared container) must be constrained to execute only on the machine where the DataStage server software is installed. This can be a trap in MPP environments.

In a word, "more".

What precisely do you mean by "number of times job ran". If there's a single termination time then surely this figure is always 1?

Is your F1 key broken?

You need SELECT privilege to a number of system tables in DB2 to be able to import table definitions from DB2. Search the forum to discover which system tables they are.

Your source is defined as VarChar(200), which is what is meant by the C representation string[max=200]. Your target is defined as VarChar(50), or string[max=50]. DataStage is warning you that this situation can result in truncation of source data, because you are not explicitly handling the truncati...

No, you can call them from any UNIX shell instead. You only need to call them from QualityStage if you need to execute them for every row processed. Don't expect speed.

Without knowing the platform we can't answer about functions exposed by ActiveX controls.

What precisely is REP_FIN_ASSET_Upd_Rej_sq (where the error is being reported)?

Does your job design look like this?

OK, you can do that in a job after the data have arrived.

So did you take a big stick to "them" and urge them to desist? After all, "they" were all too ready to blame the ETL tool!

You do NOT process exported metadata as if it were data. It's just bad practice - and the style sheets do not provide any information about relationships and dependencies; your next question is doubtless being unable to import DataStage components from the modified XML. You're on your own here!

No, because ADN died at the end of July.