DSXchange

If your script returns a non-zero exit status, then ExecSH will pick that up and cause the job to abort. Source code for ExecSH can be found in the Routines branch of the repository. You can clone it and adapt the copy for your own specific purposes if desired.

Because you have duplicate records. Each duplicate is joined to all its counterparts. Worst case, with M records on one input and N on the other, and only one key value, would be an output having M * N records.

Are the updates actually happening?

If this is custom SQL can you try using ODBC-standard parameter markers (that is, "?" characters)?

You will need to check your 8.1 installation documentation to determine whether your particular version is tolerant of "itag" installations. If it is, then the answer to your question is "yes". I suspect, however, that 8.1 needs to be standalone.

You can have a separate IA analysis database for every project if you wish. Just by providing appropriate (different) arguments for the scripts you should successfully create these databases.

Actually, 9443 is the default port number for 11.3, in which you have to use https, as http is no longer supported.

'M' is not a valid day of the week.

ORA-20000: -1846 - ORA-01846: not a valid day of the week ORA-06512

What happens on the second and subsequent iterations? That is, how are you planning to handle the archive folder? I ask this because the data files of Data Sets are not stored a folder, as you seem to think. Only the descriptor file is stored at the pathname used in the Data Set stage. Do you plan t...

You can direct the rows to another output link (for example to a text file) in the same job as they are sent to Oracle for deletion. The only "output" from create, update and delete operations is the number of rows affected, so you would not be able to capture data from "Oracle output...

I would tend to opt for Option B, with inter-process row buffering enabled.

Possibly because the exit status of your overall command pipeline was other than zero. An OK trigger can only be fired if the exit status is zero.

The order of precedence is:

1. a Failure trigger
   an Exception Handler
   automatic handling
   failure

That is, if an activity has a Failure trigger that fires, no call is made to the Exception Handler or any other mechanism. The Failure trigger takes precedence.

1. Encase your "diagram" in Code tags and tidy it up so we can clearly understand what's happening.

2. Inform us how you are partitioning and sorting your data on the inputs to the Join stage.

3. Duplicates are OK with a join.

Currently it does not.

DSODB is installed with version 9.x, but you still need to configure it (not least provide the user ID and password) in a couple of configuration files. This process is well documented in the manuals and in IBM Knowledge Center.