DSXchange

Make sure all users who develop DataStage have their umask set to 002.

Welcome aboard. :D Use the timeout to have the job sequence stop waiting after four hours. Create a separate output from the Wait For File activity, setting its trigger to "Failed" (or "Otherwise" if the first output has an "OK" trigger). The second stream can lead anywhere, maybe just to a Notifica...

All the things you talked about - and others, like project-wide defaults for job log purging and functions and system variables that are valid in expression editor - are stored in DSParams. Get one from another project as soon as possible! &UFD& is a "file name" that DataStage uses to refer ...

Click on Help within the job parameters dialog to learn the difference between $ENV, $PROJDEF and $UNSET (or just search for them in Help). Yes, it will make a difference. As to the other question, on Windows you can create a different user ID for running scheduled jobs. It's to that capability that...

See? Now we know you're trying to connect to Oracle, and exactly what the Stored Procedure stage is complaining about. A search for "anonymous PL/SQL block" turned up this post; although it refers to the OCI stage rather than the Stored Procedure stage, it may get you going on the right track.

What error messages are logged? Are any more messages logged (particuarly "from previous run..." when you reset the aborted job in Director? There's not enough information in what you've posted to help us to diagnose anything. It's in the category of "my car doesn't run, can you tell me what's wrong...

It's telling you that you invoked UtilityWarningToLog (presumably in a Routine activity) and that UtilityWarningToLog returned 1 (which it does) and that you did not have a trigger to handle a return value of 1. With routines the rule is that the job sequence will report a failure unless the return ...

You can use the Aggregator stage (rather than a Transformer stage) to return only the first or only the last of a group of identical rows.

You can put anything in the Derivation field that you might put in a column specification in the SELECT clause, including SQL expressions, aggregate functions, and so on. Try it. Maybe something like col1 || ' -- ' || col2 or max(col4) or even DISTINCT col5 . You can add GROUP BY, HAVING and ORDER B...

All of what you've stated is cool, plus there exists the ability to specify job parameters as environment variables and set the default value there to $ENV, which means "pick up the value from the user's environment". Beware, though, that you do not run DataStage jobs; you issue run request and the ...

Are you running on an MVS (Mine's Very Slow) system?

A job sequence in which all conditions are handled will finish successfully. The very act of coding triggers to handle failures asserts that you want to specify how they're to be handled. You could include a Routine actvity calling UtilityWarningToLog if you want to force a warning message to occur,...

81002 indicates nothing more than "no connection". Your inactvity timeout (set in Administrator) may have expired, or your agent process on the server (dscs or dsapi_slave) may have been killed.

This is what's known as a Lazarus post. The original question was put in 2004. Both sites mentioned now exist - the Newsletters appear on one of them.

Ah, yes, I was thinking of the ODBC replace (delete before insert).