DSXchange

There's no guarantee that "A100" and " A100" will be on the same partition, since they're different values. So you will need to make them the same, possibly via string_trim() in a Modify stage or Trim() in a Transformer stage. Values that are identical will end up on the same par...

Version 8.5 includes the opportunity to set up the repository and services tiers for high availability; it might be worth your while to read about this on the IBM website. Not really sure how you plan to do failover on a single server; failover, after all, typically happens when the server fails. Ca...

Good. We've established that the command can be found. We've also established that the syntax of your sqlplus command is incorrect. Does this form of the command (redirecting stdin) work from the command line?

Tell us the error message so that we don't need to waste time guessing.

My guess is that the PATH environment variable is not set to include the Oracle bin directory for the user that executes DataStage job.

Merci, Hugo.

DB2 wrote:A parameter specifying a filename or path is not valid.

Double check that all relevant parameters are supplying correct values. Examine the detail of the job status record in Director (or the "job starting" event in the job log) to ascertain parameter values that were used.

It's not possible. The Join stage only performs equi-joins.

Push the join back into the database (if possible) with a BETWEEN operator in the join condition.

Colon is never concatenation in the shell. Discount that possibility.

To get the required syntax, type dsjob -run by itself.

Check whether the job monitor (JobMonApp) is running.

Ereplace() in a downstream Transformer stage.

This is a database error, not a DataStage error. Find out (from your DBA or the manuals for the database) what this particular error means and, if possible, any remedial steps that might be available. If you have the error code (sometimes called DBMS code), that would make things easier.

No, unless you want to use dsjob from an Execute Command activity.

Project name is case sensitive. Make sure it is spelled and cased correctly. You also seem to have provided an empty server name. This may be the problem. You really need something like -server servername:portnumber even if the servername is localhost. I suspect also that, if you use -server option ...

Welcome aboard.

Add another output link to your Transformer stage, and mark it as handling rejects and with a row limit of 1.

Inspect the value of the TZ environment variable.