DSXchange

APT_RESPATH is only about the location of the "resource files" used to decode error codes into error text. I really think there's a problem of some kind with your connection string. It is reporting the individual elements as "not found", which is unusual. Have the correct entries...

Only partition on the first of the fields, provided that this generates enough distinct values to cover all your processing nodes. Sort on all four.

The data have to be partitioned on the first grouping key and sorted on all the grouping keys when sort method is used. But your environment variables prevent DataStage from inserting tsort and partitioner operators to achieve this, so YOU must do the explicit sorting and partitioning.

Where is the date coming from? Convert it (if required) to internal format using Iconv(), add 1 then convert it back to external format (if required) using Oconv().

Does this occur using the Administrator client too, or just the Designer or Director clients?

Could you please do the needful Premium membership is the main mechanism by which the hosting and bandwidth costs of DSXchange are met. Premium membership allows you to read the entirety of the five premium posters' contributions. It is not expensive, at less than 30c (Rs12) per day. Can you, there...

Does it (Designer) lose focus or disappear completely? If you "show desktop" can you get back to it? Using Alt-Tab can you switch to Designer after this occurs?

When you run the job from IA, what events get logged in the log visible from Director?

A year later, can you be totally certain that you have exactly the same version that datisaq is running? Or that your issue is exactly the same? Why not start a new thread?

We don't do urgent. DSXchange is an all-volunteer site; its members post as and when they can. If you need rapid response sign up with your official support provider for priority service, and learn just how much "urgent" costs. There is clearly a problem with the way you've set up DataSta...

You can't do this with dssearch. You can, however, do it with dsjob to look at the log of the sequence. Near the end of the run there is a "summary of sequence run" entry in the log, which lists all of the activities that the sequence actually ran.

Better is the right one. Funnel does a "union all" of its incoming rows from multiple inputs. Pivot does a pivot of its single input.

Learn about "derivation substitution" in the Transformer stage - you can save yourself a lot of work.

There is no IN available. You need something like