DSXchange

Yes, that's my suggested approach (once I'd understood your # to belong to "Row" and not to "=").

The EReplace() function can replace multiple instances. If you're earlier than 9.1, track down the pxEReplace() function published on DSXchange.

Each field is missing its opening quote. Have a severe talk with the data provider.

Multi-input left outer join works the same way it does in a query engine. Essentially pairwise, left to right.

"Resource" here is the decoding of the error code, and the "resource bundle" - essentially the table containing the error test - cannot be found because neither of the indicated environment variables has been set. The solution is to set one of them. To find out which stage is thr...

What should you be getting, and what format settings are you using?

Ah. There's "compile" and then there's "compile". Parallel jobs with Transformer stages can be recompiled without recompiling the Transformer stage (the bit that needs C++) if the Transformer stage is unchanged. This is to make the compile process quicker. However, a Force Compil...

Double check and triple check what's being passed where. What values are being received by the job when it starts (look at the "job starting" entry in its log)? What values are being passed when the job run is requested (look in the "job run requested" event in the sequence log. ...

Check the XSD, where the name space defns should be defined.

Check the two commands again, looking for invisible characters such as space or tab.

OK we will await the result of your investigations.

Don't forget to check for expired password.

Have you correctly marked key columns as "Key" in your metadata?

The Stored Procedure didn't return anything. DataStage has informed you of that fact.

Have you created the connection to DSODB ?

For example, can you import its table definition using the Connector Import Wizard (ODBC)?

Look at the WebSphere Application Server log SystemOut.log to determine the exact cause.

For example, the password for accessing the database may have expired.