DSXchange

Click the "Visit poster's website" link under Kim's post.

Download ETLstats from Kim Duke's website and save re-inventing the wheel.

Otherwise "roll your own" using DataStage API functions including DSGetStageInfo() and DSGetLinkinfo().

No, that's not what data rules are about. Data rules are expressions that evaluate to true or false depending on the values in the data. Data rules use join key elements to specify the relationship between tables when you have a data rule such as tablea.columnx < tableb.columny (and there is a joina...

Premium membership takes as long as it takes, it depends on when the membership director processes orders. Usually it's within 24 hours. Overseas (non US) credit cards may take slightly longer. Please note that I am not part of the administrative team of DSXchange, and can not influence that.

Try including a Copy stage ahead of the Sequential File stage.

"External" means exactly that; the code is not stored within DataStage. It's stored wherever its author decided to store it. The entry in DataStage may give some clue as to its location, but that's not guaranteed - whoever compiled/linked the routine need not have placed the shared library...

Mutex (mutually exclusive semaphores) are simply how locks are implemented on your operating system. Looks like you have had some timeouts and whatever has caused them is in the past. This makes current diagnosis pretty much impossible.

Of course there is, probably with a lot of Field() functions. The structure returned by this function is a dynamic array. How much of the information do you require, and in what format? From memory the fields are: column names key SQL data type (enumerated) precision scale nullable Each field is a c...

That was post #666 for James, on Halloween!

I've not had JobMonApp fail, so it would not be useful for me.

JobMonApp not running does not prevent jobs from running.

Quick thought is that table USMNAD.ITO (input text overrides for MNS) is not in place. Have you provisioned all elements of the rule set after creating the override?

And, as noted earlier, that error almost always stems from not having sourced the dsenv script before trying to invoke dssh/uvsh.

Locks in Information Server, locks in DataStage or locks in the database?

What kind of locks?

My car won't start. It throws some error. Unless you tell us what the error is we are in no position to assist. You should know this by now; you have posted many times and read many other posts. For starters check your own work. In your most recent post you specify Edam (which is a kind of cheese) a...

Yes you can, or in a shell script or from the operating system shell. You can use the Hashed File Calculator (a utility on the installation media) to give you the correct mkdbfile syntax. This command is the correct one to use to create pathed hashed files, though there are extensions to the CREATE ...