DSXchange

There's also || which executes the downstream command only if the upstream command fails.

OSs (there's no second e in Systems except in French)

Ah, there's no place like 127.0.0.1 !

No operation is permitted on NULL. You can't do arithmetic, you can't concatenate. All you can do is test for whether or not a value is NULL (or is not NULL).

You CAN execute the query. You don't need variable declarations or initialization within the query - you use job parameters for these.

Always check the documentation associated with patches and fixes. There is a separate link to these on Fix Central. These will tell you, for example, whether a fix is a "roll up" (includes previous fixes) or not.

If, perhaps, you were to describe your job design more fully and post the actual error message, we'd be more easily able to help. With the little information you have provided we could only guess. Consider this: my car won't start - what's wrong? Your question is currently in the same class as that ...

Aravindhan wrote:In the past 4 months, this is the first time this sequence behaves like this!

What has changed?

The uv command should have its setuid bit set and be owned by root. Therefore any user with DataStage administrator role should be able to stop and start DataStage using the uv command.

Welcome aboard.

There should be hundreds of entries in catdir - mine has 338. Looks like even your engine installation was not successful.

Stopping and starting engine tier services can be done with NET STOP and NET START commands. I suspect that's what U is seeking. I suspect they are after the ability to create a script to shut down all engine tier services, including AppWatcher, the OMD service, and the ASBNode and logging agents. O...

What about using an encode stage?

OK, got me. But, presumably, the values post migration would be set to the pre-migration values.

I understand that DataStage regards 00:00:00 as if it were 24:00:00. So you'll need to test for the date.

You can calculate the length upstream. But if you're going to do that in a Transformer stage, you may as well use the Transformer stage's ability to filter rows using constraint expressions.

Is the SQL actually passed syntactically valid?