DSXchange

Maybe whoever installed DataStage chose not to install them. Do they exist in the Packages folder on the installation CD? If you are using an image from IBM training they won't be present, because these are used to illustrate how to install plug-in stage types. But aren't they server stage types, no...

Please be more precise about the actual error messages, and how you are trying to examine the data. Are any messages generated during the View Data process?

What have you actually tried? My first thought would be to use Difference stage to determine a difference.

Was this the "Connection KO" message, the "request SQL" message or the "status of SQL" message?

That's because there is none. Email the certification address to see whether there are any plans.

This is an all-volunteer site. People post as and when they can, and usually only if they have any answer. Re-posting the same question will not help. Claiming it is urgent will not help. You are paying maintenance; contact your support provider. If it truly is urgent, sign up for premium service f...

Welcome aboard. In DataStage the metadata drives the data, not the other way around. What you seek to do is not really possible. Some people have experimented with using the Schema File property, and attempted to use a dynamic record schema, relying upon runtime column propagation to achieve pass-th...

How do you write to the log file? Surely a > operator for the first and a >> operator for the second would do the trick?

You require two hashed file stages. A passive stage can not open its output link(s) until its input link(s) are closed. So you need one stage for performing lookups (specify cache disabled, lock for update) and one stage for writing to the hashed file (specify write cache disabled).

So, what's the error message?

Class enumerates the kind of object - for example '2' is a job, '4' is a routine (at least from memory). ID is the name of the object.

LIST DICT DS_AUDIT to get a list of the column names to query - you'll probably be constraining on DTM.

What's the error message?
Where do you initialize the variable containing the SQL statement (Stmt)?
You really need to strip ALL error information from the handle - loop executing SQLError() until it returns SQL.NO.DATA.FOUND.

Welcome aboard.

Try searching the forum for this exact text. It has been discussed previously.

Query DS_AUDIT to determine which jobs were modified today.
Then you have a list of job names and date/time modified: which "details" did you require beyond that?