DSXchange

Always track down the "fault string" (error message). In this case "Cannot invoke Call with null namespace URI for method null". Have you forgotten to provide a mandatory namespace reference?

Then just use PreviousWeekdayFromDate() with a hard coded (or parameterised) date.

Check also whether RT_STATUS76/DATA.30 or RT_STATUS76/OVER.30 has reached its 2GB size limit.

Calculate the date of the last day of March as Use a similar technique for the last day of October.

Calculate the last Sunday of March as Use a similar technique for the last Sunday of October.

A separate something ONLY.

Check that your SMTP mail client is OK and that the mail server is up and running.

There is no easy alternate for the Parallel Transformer stage. You could build a list of all non-printing characters (using Char() functions) in the initialization expression of a stage variable and a corresponding list of that many dots in the initialization expression of another stage variable, an...

Where the configuration of the reading job is different from that used in the job that wrote the Data Set, DataStage uses the configuration file embedded in the Data Set descriptor file; it makes a read-only copy of that configuration and uses it to read the Data Set and (necessarily) repartitions t...

The delay here may be the network between your DataStage engine and the SQL Server machine.

How long are you waiting before you decide that the Notification activity has hung? It can take as long as a minute or two.

You can do anything in any expression (stage variable initialization, loop variable initialization, constraint, loop variable derivation, stage variable derivation, output column derivation) that the expression editor allows. You will note that If..Then..Else is one of the options on the operand men...

It depends what you mean by "combine". The analogies that you need are that the Funnel stage effects a UNION ALL of its input rows, while the parallel Merge stage effects a "master and updates" approach (which means that unmatched masters and unmatched updates may not make it int...

I'm not sure what you mean by "View". If you mean read-only, the answer is that this is driven by DataStage roles. A DataStage Developer opens jobs in read-write mode, but a DataStage Super Operator opens jobs in read-only mode. A Developer attempting to open a job already opened for editi...

After all the jobs have finished check the $JobStatus activity variable for each and, if any is not DSJS.RUNOK, generate your email.

Loop shouldn't matter - $Counter is only available once per iteration.