DSXchange

There is only one way to prevent a job from aborting, and that is to design it so that it does not abort.

Some aborts (for example database unavailable) can not be designed around.

There is NO WAY to demote an abort message to a warning; indeed server jobs do not support message handlers at all.

Unfortunately there's only "Provision" or "Provision all" on the menu. But thanks for the suggestion.

A bit busy with real work to do much diagnosis right now. But I am fairly convinced that it's something to do with the repository, perhaps privileges.

What information do you believe to be lacking from the manual?

It is the nature of such queries to return nullable columns, to be on the safe side. This is nothing to do with DataStage. However, the fact that you have made the columns on the output link, to which you map the columns in the result set, not nullable has caused the alert messages to be generated. ...

Welcome aboard.

Why do you want to do this?

There are plenty of extant tools, including DataStage's own reporting mechanisms and tools like DwNav from Kim Duke.

Welcome aboard.

If your data are sorted, then this is a straightforward application of using stage variables to compare the current row with the previous row.

However, the logic in your example does not appear to match your words.

Tell us WHERE you're performing this query and post the entire detail of the warning message and we may be able to comment cogently.

Where are your logs, local to the project or in the unified metadata repository? The former is considerably faster.

The CR may have gotten there if the initial target of FTP was Windows. You should be able to specify the Record Terminator String format property as "DOS-style" and thereby not need to make any further changes to your design.

When attempting to provision a rule set (the SET file itself) using "provision all", the following error was thrown: Error exporting object from repository to file 'Quality\AUCITIES.TBL', error number=-3 QueryFailed This occurred under my regular login ID, the DataStage/QualityStage admini...

Create DSHOME as a user-defined environment variable. It contains the pathname of the DataStage engine directory.

It was a question. Does the fill arrive by ASCII transfer (FTP) from a Windows-based system?

You don't. You achieve it with a Surrogate Key Generator stage with an input link, that receives the results of the query.

Please re-read my earlier post more carefully.

Then your installation of the clients is incomplete.

Tell you what, you research in the QualityStage User Guide the answers to your questions and post back here, and we'll help to clarify any remaining doubts. When you post back, don't address your question to U (one of our posters) specifically - U doesn't check in all that often. Note, perhaps, that...