DSXchange

If all you are talking about is assembling a 'full' address line from the various (clean/validated) parts then no, you certainly don't need QualityStage just for that.

You'll have to wait for IBM to get back to you on your exact situation, but anecdotal evidence here suggests it must be the version noted in the docs. Unless another AIX user has experience with this exact same combination?

As noted above, just use stage variables.

Still, this is a simple pathing problem. Any command has to be either in the $PATH to be found or fully pathed or an appropriate relative path needs to be used.

Well... if the goal is to stop processing any subsequent rows without aborting, you can't. Best you could do is set a stage variable to start skipping all records after that condition is detected but you'll need to run through the entire data set.

Do you mean anything special by 'a set of nulls'? Sounds like you just need a Reject link set to 'Abort after 1 row' - as long as 'stop processing' means abort that is.

So your O/S is actually Windows?

What happens if you simply add it? I would suspect if it still doesn't work it's an issue in that old/unique version.

This as a way to obtain the derivation? Interesting, don't recall seeing that one before. It's not new in the 8.x release, is it?

Kindly explain what you mean by 'special' characters.

Well, that $APT variable ( and perhaps one more) have made this work for others. What 7.x version are you running?

Perhaps with an advanced uderstanding of the underlying repository you could engineer something directly from there. The API will get you most of that, but not the derivations. Otherwise, you may want to look into generating a job report and then processing that. There's an icon in the Designer that...

Sorry, no, not really. Any kind of a pattern here when this happens? Different jobs and projects, ok, but are other activities running on that server at that time? Perhaps anti-virus? That's one thing that pops into my head as a possible culprit that we've seen wreak havoc in the past.

Many ways. A custom routine could get and format the date you pass to the stage, you could get it from the operating system with an Execute Command stage, etc etc.

Well... it's called a "backup" - do you have one? Could be exports of all projects to .dsx files or it could be file level "system" backups. Without one or the other, I'm afraid that not only are all of your jobs gone but you'll need to reinstall DataStage as well. Perhaps someon...

Can you post your XPath Expressions, please?