DSXchange

What functionality would that be, Arnd? It all sounds very "Server like" to me. So, Oracle apparently. And timestamps in that ISO format can be compared directly as strings.

Please post your complete & unedited 'timestamp conversion' error so we can get some idea of the where and the what.

Seems like it's time to open a case with your Support provider.

Why ask for "Resolved" when there's nothing to indicate it ever was? Now it just seems like it is "resolved" because you told Mark to mark it that way. What am I missing here?

So four output links, each with a constraint. As noted, you don't change the "execution flow" of the constraints per se but rather the order that the links execute - their output order. And there's a button to do that inside the transformation editor.

Read the multiserv.pdf document in your Docs directory - the "Installing Multiple Servers" guide.

Yes - every Sequence all the way down will need this functionality. A job abort needs to propagate all the way back up the food-chain, aborting each Sequence as it goes, including the highest level 'master' Sequence. Each Sequence must abort in order to restart from the point of failure origin. No f...

ps. This "fatal ODBC error" - does it in fact abort your job? Meaning does the job end up in an "Aborted" status in the Director?

You don't need a custom expression to check one value, switch it to Failed - (Conditional) and see if it works more better with the Otherwise trigger that way.

You don't really "execute" a constraint and they don't really have a "flow" so not sure what you are asking. Are you saying you have 4 conditions in a single constraint and you want to change the order the conditions are evaluated within the constraint at times? If so, that just sounds like "if-then...

So what was the resolution here?

You need to configure DataStage for Oracle access. The process is documented in the Plugin Installation and Configuration Guide and involves changes to your dsenv file. Have you performed those steps yet?

You really shouldn't have an Input and an Output tab in an FTP stage AFAIK. Are you transfering a file from one remote server to another? In that case you would link two FTP stages, I would think. To send a file from your DataStage server to a remote server, you use a Sequential File stage to read t...

In a single project on a server where multiple projects exist? You'll need to add the Environment Variable to the project via the Administrator and give it the new value there. That value will automatically be set for every job's environment in that project when each job runs.

What else aborts other than the Sequence? Check your triggers on the Job Activity stage(s) in the loops. Something is causing the loop to end prematurely, or you are branching outside of the loop. Can't tell from just those messages, however.

Technically, an aborted job does return a "3" and the status value for that is DSJS_RUNFAILED while finished with warnings is DSJS_RUNWARN. Check for those values in your Triggers.