DSXchange

The Transformer Stage Properties will be different, with more options in the PX version. Easiest place to check may be the (stage) Variables tab where the PX one will carry SQL Type columns not part of the Server / BASIC Transformer.

If all you're looking for is SQLSTATE and things of that nature, a reject link from the database stage should do the trick. Or you may be able to farm that from the job's log. But in either case the Enterprise stages are not well known for their error reporting capabilities. However, I've heard that...

Then your Salary field is not null. You may need to add a check for that field being "empty" as well. What data type is it?

And you've verified that path that you log is correct and that it not only exists but you have the proper permissions on it as well? Does this work when you 'Test' it and only fail in the job or does it not work at all yet?

FYI - You could cut your derivation back to simply this and achieve the same result, no need to an IF-THEN-ELSE structure.

InputColumn matches '...ABC...XYZ...'

Can't say I've ever had a need to try anything like this up till now, so I can't help until I get some spare time to experiment and who knows when that would be. Hopefully someone else can be of assistance in the meantime.

If you already have a solution using something like sed or awk (etc) then I would just stick with it. Building it again as a BASIC routine would be reinventing the wheel. IMHO.

What do you think the "current directory" is when the routine is called? Best to stick with full pathnames to avoid issues like this.

For this one job, sure. The trigger however would be a forever 'solution', regardless of source or circumstance.

Only if that's the way you always want that handled.

You should investigate the Matches function. Search here or check the docs for the syntax.

So, for example in the first line the number 24257? I'm not sure off the top of my head what it is but the man page should let you know.

Nope.

Did they not also receive instructions on how to apply/install it at the same time? They certainly should have.

From what I've seen, most patches for 8.x are applied from the client side, that doesn't necessarily make them a 'client patch' however.