DSXchange

I really should add to Vincent's more serious post that a tool such as QualityStage can be an immense asset in standardising the form of data, which is part of cleansing. You can develop separately then iintegrate into DataStage job streams or not, depending on how you want to process. Madhu, you wi...

Every well-implemented one!

I've seen some references to semaphores in this forum, but cannot find the right manual to describe them properly. It sounds like I would have to nominate which lock number each job was to use, rather than allocating a pool of semaphores which every job could use. Next time you're at a TCL prompt, ...

Serks

In that particular situation, quantity matters too!

Multi Job Compile (available from the Tools menu) allows you to select just uncompiled jobs.

No.

Bulk loaders are database-specific. OLEDB is a generic mechanism, like ODBC.

This is a direct corollary of the rule that a running job can not change its own parameter values.

The nullable property is purely documentary within DataStage. It enforces nothing.
It serves as a valuable check for developers not to allow nulls to get through to columns in target tables that are defined to be not null.

Many databases, among them UniVerse and UniData (from IBM), D3 (from Raining Data) and jBase (from jBase), use hashed files to implement their tables. Since DataStage is a derivative of UniVerse, you can definitely use hashed files as tables. To do so, as others have intimated, you need the table na...

Specify an appropriate user ID and password when invoking sqlldr.

The first one of these I ever encountered (configuring an ODBC driver to get tables back from an AS/400 machine) took just short of 70 hours (that's three days) to get all the table names back. This was in an IBM lab! We quickly learned to configure filters in the ODBC driver!

Everything you need is in the error message. Read it carefully. The DB2 coordinator node is not mentioned in the configuration file under whose aegis you are running the job.

There is a button on the Container properties window that allows you to synchronize the link names on either side of the container inputs and outputs.

7.5x2 (which I also have installed on a laptop) is the first Windows version of DS EE. As with most first versions, it is rather flaky in places. And the machine's capacity really does limit the degree of parallelism that you can achieve. My laptop runs 3.5GHz Pentium processor, has 2GB of RAM and 2...