DSXchange

There is an Ereplace() for parallel - it was published right here in DSXchange.

Try it with forward slashes. The orchadmin utility really runs under UNIX, so expects forward slashes in pathnames. It will also be upset by spaces in the pathname, so you need to quote the pathname. orchadmin describe -s "D:/my datastage flat file/emps2.ds" Try to use a more meaningful fo...

Make sure that the parameter reference (the string between the "#" characters in the passive stage field) exactly matches the job parameter name (in the job properties dialog).

Then you need to use the Administrator client to build the Chinese map(s) that you require (probably BIG5 or GB2312, but also build the map of the same name but with a "-CS" suffix, which is used for communicating with your DataStage client). This only needs to be done once.

That should work. You can use date arithmetic to get the two required dates where the key is the same. Set a flag in that case, use that flag to output the rows to a separate output, and bring them all together with a downstream Funnel stage.

It's probably the connection to AS/400. Recall that every file on the AS/400 can be a "table", so when the connection starts and it asks the AS/400 for a list of tables, this can be huge. You can (should) configure the client software (or ODBC DSN definition) with a file name filter.

Four Data Set stages, one Funnel stage. The Data Set stage can only read one Data Set (which is, itself, a parallel structure, so has at least as many data files as there are processing nodes).

When you browse, and then select My Computer, can you see your G: drive then?

It was the only way in back in the days of DataStage 2.2.

Someone has to be the pathfinder! Please post your "gotchas" here.
Best of luck.

Is this, indeed, a Transformation Extender (TX) job?

Yes.

Stop trying to do so much at once.

Read about the Matches operator in Transformer expressions.

returns "true" (1) if the incoming value consists of zero or more numeric characters followed by "." and then by two numeric characters, and "false" (0) if it does not.

Welcome aboard. If you are looking for a professional consultant to assist, then there IS an easy answer. Otherwise how about you begin by defining "performance" in an ETL context. Actually, before you do that, search the forum for any/many of my explanations why rows/sec is a useless metric of "per...