DSXchange

What are the source and target? What are the source and target data types?

Welcome aboard. You need either the patch or Fix Pack 1 to get the new XML functionality. You can get either from IBM Fix Central.

The only thing you need is DataStage Administrator role. Once the project has been created only administrators have access to it until some project roles have been specifically granted via the Administrator client.

Should be fine, so long as you carefully manage their expectations as to performance (which won't be "fine").

If you remove the &PH& directory itself you will not be able to access DataStage in that project (at least until the &PH& directory has been re-created).

dsjob is the DataStage command line interface. iajob is the Information Analyzer command line interface. istool is a command line interface for Information Server Manager. There are others. They are all documented (at least in version 8.5).

There's nothing wrong in the script except that you don't wait for the job to finish before attempting to restart it (there's no evidence that you're using $i as an invocation ID). It is not possible to run a job that is already running.

So, what are you trying to accomplish here?

Welcome aboard.

Product information and success stories are freely available from IBM (for example from their web site). Manuals are also available from the Information Center (again IBM web site).

Full outer join.

Three-output Filter or Transformer stage constraining on whether A is null or B is null or neither is null.

Is ORACLE_HOME correctly set in dsenv? Perhaps it is using a different value from that used by your interactive user? Clutching at straws a bit here, it's difficult to diagnose these things remotely.

From where are you attempting to execute an SQL statement that contains "BIDATA"? It appears that you're trying to do this from a TCL prompt, rathe than against your database.

Looks like an incomplete entry in tnsnames.ora file - one (at least) of the configurations lacks a SERVICE_NAME property (in the CONNECT_DATA sectioon) but requires one.

The output column must be marked as Nullable, otherwise a default value will be substituted.

What do you mean by "doesn't work"?

Do you have NLS installed and enabled?

If not, you will struggle to process accented characters, etc.

In that case there's a problem in the logic of your job design, or errors are occurring about which you have not informed us but which would be logged.