DSXchange

Yes, it's server jobs that behave in that fashion. There are different rules for parallel jobs, apocryphically. Alas, they don't seem to be written down anywhere.

There have been a number of posts on resetting sequences, this one for example provides a function that can be used.

And, when you do solve it, please post the solution.

Yes. If you need that to be tested, apply parentheses and/or change the order.

Doesn't matter. The semi-colon is also the unconditional command separator in the DOS shell.

It can be dynamic (Type 30), but is created as Type 2 by the function. Type 18 would probably be a better choice once modulo exceeds 1.

You have all the table and column names your require in that query. Why don't YOU have a go at designing a recursive query?

If you have not got enough space, whether it's memory or disk space, your hardware vendor will be happy to sell you some more space. Otherwise you must reduce total demand for space. Run fewer processes simultaneously, tune the job designs (buffer sizes, memory limits for sort, for example), add mor...

Why not simply select the DEP_DATETIME and perform the mapping within DataStage? You can use a stage variable in a Transformer stage, for example.

"A democracy in order to function at all has to be reasonably interested in some of the more serious issues and they have to rely on the media to give them a halfway decent accurate picture of what's going on. I don't think we've got either in America at the moment."
-- John Cleese

When's the interview?

ITAG isn't a solution, it's an installation strategy. Read the Installation and Upgrade Guide for more information.

Does the Transformer stage have a constraint on the output link that might explain fewer rows being emitted than consumed? The second error message suggests that the stage did not read its input right through to the end. Are there any other warnings/errors in the job log? Break the job up to identif...

Yeah, your hardware vendor!

Does this occur for all projects or just one? Does it occur in all clients? Can you connect with Administrator client? If so, does the list of projects on the Projects tab populate correctly? If not, one of the system tables (UV.ACCOUNT or UV_SCHEMA) has become unsynchronized and probably need to be...