DSXchange

Is that the exact error message? Does the stage name in the error message refer to your MSOLEDB stage or to a preceding active stage? Is it STAGECOM.ARR(9) or really "Array 9"? If the latter, it's something inside the MSOLEDB stage and you're going to need to get the answer from the vendor (unless i...

The server job Merge stage performs exactly the function you specified, which is an inner join. Read about it in its own manual (Merge.pdf).

Go to Director. Select your job. Go to the Project menu, choose Print. Check the Print to File check box.

It's called "Filter" before the table names are listed. Sometimes "Advanced".

How about the following, which returns 0 for a valid string and a non-zero value otherwise?

DataStage does not prepare SQL when compiling, so it could not detect SQL syntax errors at this time.

Validating the job would have picked up the SQL syntax error.

orchadmin delete /detld1/etl/ascential/Ascential/DataStage/Projects/CTI_London/IAM/staging/FXRate_20050525_129.ds

Is not the correct command orchadmin rm dataset ?

Looks like you only have Checkpoint restart enabled on the top level job sequence. What happens if you enable it on lower levels also?

Can you try the same test using the UNISEQ function rather than SEQ ?

The UNISEQ function returns the Unicode code point of the character that is its argument. This may give some insight into the block in which your strange character belongs.

Edit the post and check "Disable Smilies in this post". ;)

Clusters are OK. Server is installed on only one machine in the cluster, but can access disk resources on the others. Parallel can operate on all machines in the cluster. However, there is no automatic failover available in DataStage. It would just be too difficult to keep track of committed and unc...

How about eight levels of nested containers, which I once encountered? It's more than complexity, though. We need to address maintainability (of course, since DWs are around for a long, long time) and we also need to address the question of what is optimal design. And that's a bit of a moving target...

Serks?

What happens if you specify NONE as the map?

Have the shell script exit with a status code other than 0.

You can detect this with the fourth argument of DSExecute, and set the ErrorCode argument accordingly.