DSXchange

This "loss of functionality" has serious implications for transfer of environment variables from project to project, and probably should be reported to IBM as a grizzle.
Or, if it's a bug in AIX implementation only, again IBM needs to know about it.

The error message suggest that for the executing user APT_ORCHHOME is empty. As Arnd suggests, include an echo command in the script to verify whether or not this diagnosis is correct.

What happens if the Rejected Mode is Output and you do have a reject link?

The obvious thing that might have changed is the version of DataStage. Have you ever had this technique work with an 8.x installation? We know it's OK in version 7.x, but that doesn't have a common metadata repository (XMETA). My guess would be that the common repository is now the single source of ...

Yeah?!!

Please elaborate on how you can change an operating system setting through the DataStage Administrator client. Particularly something like ulimit, which requires superuser privileges to increase.

Microsoft has recently re-vamped the MSDN download site from which you can get the compiler - the only option available there is the .NET 2008 Express Edition compiler, which is not yet supported for Information Server. To get the .NET 2005 Express Edition compiler go to Visual Studio Express Editio...

You can not use this query with a hashed file stage, because this stage type only supports "equi-join". If you use a UniVerse stage the query is exactly what you have except that it uses "?" rather than numbered parameter markers.

The only way to get a list of the jobs USED in a job sequence is to read the log. The easiest way is to check the event called "summary of sequence run". This is because the logic of a job sequence (triggers, nested condition activities) may cause some of the jobs in the job sequence design not to b...

Multiply by 100?

128 is the internal representation of NULL. Avoid it as a delimiter!

No, "all T" is "all T". What makes you believe that there should be more patterns in this field than you are getting? Typically there are few patterns.

Please read/post the entire error message which will, among other things, include the name of the operator that generated the message.

Assuming, of course, that there is no other object (stage name, link name, etc.) called Curr_Type. Your search/replace does need to be a bit more selective than sreddy suggests.

This might be easier by editing an export of the (jobs in the) project.