DSXchange

Job sequences only ever run sequentially, and only ever on the DataStage server machine itself, not on any other node in an MPP or grid environment. That's because a job sequence is really a special case of a server job. You can, of course, create parallel streams of processing in a job sequence, bu...

One solution would be to force the entire job to execute sequentially. Which defeats the purpose of having this parallel engine and is, as others have noted, unnecessary. Then again, for only 10,000 rows it would probably perform adequately.

What happens if you use an unsigned data type in DataStage? (I suspect it may be leaving a space for the sign character, though why this would accumulate I have no idea.)

Yes. The whole point of a Connector is so that you can have a pre-tested, re-usable component. <amusing anecdote> When this object was proposed marketing came up with the name "frictionless connector". The adjective was dropped when some people started referring to it as the KY Jelly stage. </amusin...

The Monitor shows the status of stages, not of the job. The job itself may still be running, waiting for the sort to complete. To get the last-recorded status of the job, use Status view in Director. To find out how far the job got, use Log view in Director. If the job had been stopped (for example ...

It usually means exactly what it says - someone else (or even another session from your client) has the stage open, either in a Monitor or in the Designer. Its record in the Repository database is therefore locked.

Zero-based in Modify stage, one-based in Transformer stage.

This is because they wanted the Transformer stage to use BASIC-like expressions, which the compiler would translate into C constructs.

Sometimes, when asked by Dennis to do so. This class is offered by DSXchange as another mechanism to fund the site's costs. Contact Dennis (mailto:editor@dsxchange.com) for more information about when it is next to be run.

Then uncheck the Range check box, look up the max value, and perform the comparison in an expression in a Transformer stage or Filter stage.

Numeric data are stored in binary format, you can not affect their display. You need to convert to string to have any control over the display format.

Are you being interviewed, or setting up a "prepare for interview" site?

Was on a ten hour flight with no internet access.

Only the functions in the drop-down list are available. Not all BASIC functions have equivalents in the parallel Transformer stage. In particular there is no equivalent of Oconv(), Iconv() or Fmt().

Wherever you can use an expression; includes Transformer stage but also expressions in job sequences (though "input column") takes on a different requirement there) and within routines.

Wrap your design in Code tags to make it easier to see what's happening. You probably have not committed the insert until the end of the job. What is your rows/transaction setting?