DSXchange

Does Job A have a specific Failure trigger? This would be used in preference to the Exception Handler in the event of an abort of job A.

In Director choose Print from the Project menu.

Within the Print dialog, select the Print to File check box.

This is the easiest solution to the original question.

Assuming you've isolated the element <tag> stuff </tag> then the Index() function is the way to go. Make use of its capability of having an "occurrence" argument, to search for the character position in the string (element) of the second "<" character. Index(InLink.TheElement, "<", 2&#...

What happens if you start using generated SQL (long enough to add the job parameter for the schema name) then switch to SQL Builder?

The moral of the story is to strive to write jobs that don't abort.

It's my understanding that $HOME is set by the general UNIX login script, for example /etc/profile, that is executed by all users.

What DOES the new output file contain?

What DOES the new output file contain?

Can you please check to determine whether this routine was written in-house at your site? I don't have it on my system. The same is true of the "SCD2 Transform". What is its provenance?

In a stage variable initialization expression, a stage variable derivation expression, an output link constraint expression or an output column derivation expression just use the constant (for example 52).

If it's not really a constant, then use a job parameter.

It would not have made any difference. It's Oracle that needs the entry in tnsnames.ora. If you, as a DataStage developer, had such a GUI, you would still not have permission to put it in to tnsnames.ora where Oracle insists on it being.

In a world of "user pays" maybe only those who pay up get added?

Short answer - you have more options for being selective with the data if they are in a table compared to if they are in a sequential file.