DSXchange

Good point, but original question required "in Transformer stage".

You ought to have no problem having UniVerse side by side with DataStage; I run that particular combination. UniVerse RPC uses port number 31438, while DataStage RPC uses port number 31538. The only problem is that both telnet services (on Windows) want to use port number 23; disabling either or bot...

"Unhandled pattern" is a column in the report from an Investigation. If that field (unhandled pattern) is populated, then the row has an unhandled pattern. Note that there is also "unhandled string" which can be useful in deciding whether or not you need to create a new rule or a rule override.

The text marks indicate that your column width may not be adequate, rather than separate lines (unless you are selecting from a multi-valued field, in which case you can use DataStage's "normalize on" capability). You can override the default column width with a FMT keyword in your UniVerse query. B...

There's a link on this page to some routines including one that adds months to a date.

The best solution will have 20 output links. Resize the stage icons so that it doesn't look so messy. Depending on the target, you may not even need a Link Collector; there's no reason that you can't have twenty links feeding independent inserts into a database table. Or even into twenty separate te...

By default, none in server jobs. It is recommended that you configure the deadlock daemon for autostart (in dsdlockd.config file). Depending on how you use the product, you may need other services started. For example, if you are using the QualityStage plug-in, then you will need qsrtmngr to be star...

No, provided you have the memory available to support your settings.

That's surprising, as the link variables work well with ODBC stage types. Let's say your output link to SQL server from the Transformer is called SendData and your output link to your rejects file from the Transformer is called Rejects. You have marked Rejects as handling rejects by checking the box...

There are two numbers associated with a UNIX DataStage process - the internal DataStage number and the process ID. Which did you choose for your UNLOCK command?

"0X" in DataStage BASIC pattern matching is a wildcard. The value marks (indicated by system variable @VM) create a multi-valued pattern, so that the Matches operator is satisfied by a match against any of the individual patterns. So my expression is true if InLink.FirstCol has a value that ends in ...

Congratulations on successful detective work! Yours is a good solution.

You could have used a filter command in the Sequential File stage, perhaps using sed or awk to change the column in question. But there's nothing at all wrong with your solution.

I don't think that will help - those codes are job status codes. These only become the exit status of dsjob if the -jobstatus option is used (otherwise they are available on stderr from dsjob). The value 6 is not represented. I am not aware of a published list of exit codes for dsjob. Source code fo...

Why not use a Hashed File stage or a UV stage with the "create" option selected?

You do need to be alert to the fact to which Kim alluded, namely that "Input" and "Output" are stage-centric terms. A stage that reads data from a persistent store will have an output link, whereas a stage that writes data to persistent storage will have an input link.