DSXchange

You can use Oconv(InLink.TheString, "MX0C") to convert all characters to hex-encoded equivalents.

Many parallel stage types support a reject link. The descriptions of each in the manuals will tell you which they are.

QualityStage match against list of valid domains. Survive matches from the valid list.

No. At least nowhere that I've looked.

(Well, that's not entirely true - they are documented in my DataStage Administration class - though not, curiously, in IBM's Administering DataStage class.)

QualityStage would be my preferred approach.

Both Soundex and NYSIIS capability are built in to QualityStage. You could (as one suggestion only) match against a list of valid domains.

Congratulations on finding a solution (even if we don't know what the cause of the problem was)! Please mark this thread as Resolved.

Welcome aboard. :D

There is no way to achieve this in a server job.

Don't believe so. I understand that metadata capture unconditionally assumes that any function (including NVL) may return a nullable result.

The only partitioning algorithms that could cause a self-deadlock (assuming you're not updating the same table as the one from which you are reading) are Entire or a key-based algorithm (Hash or Modulus) where the partitioning key differs from the table primary key. Every other partitioning algorith...

Even so, "expression = @NULL" is invalid.

expression = @NULL is not a valid thing to do. You are attempting to compare the result of expression against an unknown value. The result can only be NULL (unknown), which causes a constraint expression to return "false". What you need instead is IsNull(expression), which returns "true" if the res...

Not quite. @INROWNUM is the number of rows into the Transformer stage, not the number of rows sent into the target. @OUTROWNUM is the number of rows sent to the target, each of these may or may not be successful. You need reject handling in the job to be confident about how many of the rows were suc...

Please post a message indicating how it has been solved and mark the thread as Resolved.
This will assist future searchers.

(Auto) is the same as "Same" when the link is between two parallel stages (neither of which is a reference link). Partitioning guarantees that each row is processed on only one node. Mutually exclusive constraints guarantee that each input row (on any particular node) is directed to only one output ...

The row number that you are reading from the file is reported in the Transformer stage via the @INROWNUM system variable. The number of rows that were sent to the target (whether successfully or not) is reported in the @OUTROWNUM system variable on each output link from the Transformer stage. You ca...