DSXchange

DSMaskExecArgs is one of your routines?

The error message suggests that a routine of this name has been edited (or even just opened and saved with no changes) and not yet re-compiled.

Except that the middle one needs to be SUBSTRINGS (I assume you made a typo here) that will work.

Another possbility - which I believe is better self-documented - is

The Exception Handler has activity variables that report which activity failed, an error number (not much use) and an error message.

Fix the 20%.

Use activity variables from the Exception Handler in the subject of the email sent from Notification activity.

That information is not documented.

As Craig notes, use a server job. In the Sequential File stage specify that it uses a Filter command and setup the filter command as cat file1 file2 file3 ... The stage will read stdout of the filter command rather than the file name you (have to) supply. Add downstream logic to discard any header r...

What have you tried? We're really here to help you to develop your skills, rather than to provide solutions. (Some of us are in business doing the latter, but that doesn't count in this discussion.) So please post any analysis you may have done of the problem (apart from "ask DSXchage how to do...

What Craig said, but stronger. If you were to write your own you would need to encapsulate the DataStage C API in order to have the ability to set parameters, request runs, discover status, and so on. A review of the source code for UtilityRunJob will give you the logic. You would also need to take ...

DataStage is telling you that it can't transfer two identically named columns to the output of the stage. You could rename - or make copies of - the columns on one of the input links if you need both in the output.

If you use link naming conventions, for example naming an output link tablename_OUT, then your task will become a lot easier.

@RECORD is a system variable that contains the entire record (as a dynamic array) from a DataStage hashed file. DS_JOBOBJECTS is a hashed file. There is no metadata associated with @RECORD. The structure of records in DS_JOBOBJECTS varies depending on what kind of job object is being stored. Metadat...

What have YOU tried?

It is possible. What have you tried?

You can download a connector for MongoDB from developerWorks. It's intended for 9.1 and later, but source code is there so you may be able to tweak something that works from 8.5. No guarantees, however.