DSXchange

There's no option for doing this. Either modify the dsjob program (source code in the Developer's Guide manuals) or parse the output of the standard dsjob command.

After using the Compare() function you need to test its result, rather than that of the Status() function.

All arguments are passed by reference, which is why DataStage generates the warnings, "just in case". There is a trick to emulate pass by value; in the caller use an expression rather than a variable. The easiest way to do this is to enclose the variable name in parentheses. This works because it is...

dssendmail_template.txt is in the project directory on the server. You want to customise what DataStage does out of the box; you will need probably to create a job or routine to extract the warnings from the log; for example using a query constrained on severity code. SELECT "TIMESTAMP", &...

is there any in-built mechanism available with DSEE ...
No.
That's why utilities like Kim's are so valuable. :D

Welcome aboard! :D The message tells you that the job run under control of the job sequence aborted. The name of this job is probably part of the error message, though you've replaced it with the metasyntacic variable <job name>. What you need to do is to inspect the log for that job (<job name>) us...

Among your DataStage documents you should find one called XMLPACK_20_Designer.pdf. This is the manual for XML PACK v2.0, and explains how to use all the XML stages. If you read that, it will save me having to paraphrase much of what's in that manual. It should be in C:\Program Files\Ascential\DataSt...

What is field 8? Remember that numbering is zero-based. 0,1,2,3,4,5,6,7

It's not possible. You want to do something without creating a DataStage job and get it to happen via dsjob, the command that runs DataStage jobs? The question is internally inconsistent. Further, DataStage is metadata-driven; there is no out-of-the-box mechanism for handling metadata dynamically. Y...

It's almost certainly indexing in the Repository. Find a time when there are no developers connected and no jobs running and, logged in as DataStage administrator, execute the command DS.REINDEX ALL (from the Administrator client Command window or from a telnet session running dssh in the project di...

There are three XML-handling stages; XML Reader, XML Writer and XML Transformer. You need the XML Writer stage. Check with your support provider about obtaining these - they're normally supplied with the RTI components, but you can (could?) also order the XML PACK.

Take an extra output link. It has one integer column. The value sent along this link is @INROWNUM. Run it through an Aggregator stage in which the Last function is specified.

The usual solution to this is a custom Routine that uses a set of exception words, perhaps stored in a table (or hashed file). The following pseudo code explains the algorithm. Ans = "" LOOP Get Next Word UNTIL No Word Found Lookup Word In Exceptions IF (In Exceptions) THEN NewWord...

Can you do it with regular FTP (that is, not with DataStage)? If so, have DataStage generate a local file then run a script to perform the FTP operation. As far as I know there is no property of the FTP stage that allows a file to be created as an FB file. Indeed, I don't think that the Sequential F...

The error "unable to locate NLS map" usually means that the map you have specified has not been loaded into memory. You will need the Administrator client to determine which NLS maps exist on the system, and which of these have been loaded into memory. After you specify a change to which maps are lo...