DSXchange

You have lost the record in DS_JOBOBJECTS that describes the link, but the reference to it has not been deleted from its parent object (one of the stages to which the link was connected). If the link is one that has been deleted from the design, the correct solution is to delete the reference from t...

If col2 is blank your expression is effectively attempting to divide by zero which the DataStage or UniVerse documentation will tell you is an illegal operation and will cause the executing process to abort.

Yes.

Be careful if using QualityStage, however, because it insists on Bourne shell. Its own "shell executable" is a symbolic link to /bin/sh.

I was thinking along those lines - multiple processing nodes all attempting to create the same table. The obvious solution in a parallel environment is to have a serial environment (you or the DBA) look after single-threaded processes, such as CREATE TABLE, and have the parallel streams then process...

Of course you can write one. But what do you want to do with it then? If it's "UniVerse" SQL you can execute it directly, via DSExecute. If it's not, you can write it to a file as others have noted, then invoke some kind of script to execute it. Another possibility is to write a routine that is an O...

No blast, the scenario described can happen, if the deadlock daemon is configured automatically to resolve the deadlock. But, by default, the deadlock daemon does not resolve deadlocks; it only detects them so that the administrator can release them manually. It's one of my favourite things in the p...

Just to clarify, I asked "where", not "what".

Try the MatchField() function.

This will return the alphabetic string following the numeric string, or "".

There was a team of engineers who coded the Peoplesoft Informatica mappings into DataStage routines by hand. This speaks to me about the lack of an automatic conversion tool.

You got away with it because VOC is a static hashed file (implemented as an operating system file, not directory) and because no-one was using the VOC at the time. It would have been safer, under the same conditions, to delete the damaged VOC before performing the copy. There ought to be no serious ...

I agree that both have their place, and can't see server jobs being phased out any time soon. There's just too much investment in server job development work out there. They may refurbish the Engine - this has been an ongoing project since version 6.0 (the split from UniVerse) but I think it's safe ...

Hmmm... pretty sure that's what I said. Nope. Your design, because of the All sequencers, waits till all ten have finished before starting the next ten. A design with ten parallel streams of Job Activities - no sequencers needed - will sustain execution of ten jobs/job sequences while ever this is ...

Even better for identifying data problems are ProfileStage (formerly known as MetaRecon) or AuditStage (formerly known as Quality Manager).

This is exactly what those tools do.

I seriously doubt that the MetaBroker for Informatica has the ability to grab design-time information. No other MetaBroker does. They concentrate on technical metadata (table definitions, etc.) and process metadata.