DSXchange

Just been to a presentation at IOD where a quite competent team reported a multi-week development effort around a series of a few dynamic ETL jobs.

Well done, though you'd already claimed to have 31538 opened for both directions, which is why I was still musing about it. Port 31538 is the port that DataStage clients used to connect to the DataStage engine - specifically to the dsrpcd process when connecting.

In version 9.1.2 Ereplace() is available for parallel jobs. For versions 8.x and earlier you can use the pxEreplace() function provided here on DSXchange.

There's no such thing as a trial version, but you can buy time on DataStage in the Amazon cloud relatively inexpensively (or in the IBM cloud, a little more expensively).

Is there a flag (like the -c option for the sh command) that forces winexe to return? If so, use that,

rberman wrote:These scripts were working fine just a few hours ago

What has changed?

Another possibility is to use environment variable job parameters. These can have their default values edited outside of the job (usually using the Administrator client).

Ereplace() should work. It performs substring replacement. Simply replace the unwanted substring with "".

Convert() is good if the characters to be removed do not occur anywhere else in the data.

Otherwise you'll need a mix of Index() function and substring operators.

Prevention is always better than cure. Don't write them that way. What kind of activity under the "exception being handled" stream is aborting?

Doesn't Search work for you? This technique has been described on a number of occasions. In your case you need two stage variables. Let's call them svNewPreviousSalary, which will become the value of the Previous_Salary output column, and svPreviousSalary, which will be used to "remember" ...

Yes you can, but why would you want to call dsjob this way? You should prefer the DataStage API functions such as DSAttachJob, DSSetParam, DSRunJob, DSDetachJob, etc. For other UNIX commands the preferred approach is to use the DSExecute() subroutine, which captures both the output and the exit stat...

For starters, it's not urgent. It's the weekend. DSXchange is an all volunteer forum whose members post as and when (and if) they can. If you need urgent support sign up with your official support provider for premium service and learn just how expensive "urgent" can be. Parameter values a...

If what you say is true then your Sequential File stage is running in parallel, which seems doubly odd. Are you sure you're not seeing a "fan out" icon, which indicates partitioning rather than collecting? You do have access to view the score. Request the score be logged using the APT_DUMP...

Yes.

Welcome aboard.

If it runs in parallel it will use the DB2 partitioning algorithm.

If you should wish to enforce this, set the execution mode to parallel and the partitioning algorithm to DB2 - you will be prompted for the name of the table that defines the partitioning.