DSXchange

Give large amounts of money to a competent consultant. Magic happens.

Conditional lookups are fully supported in the parallel Lookup stage. Who was asleep during class? A server job solution to implement true conditional lookups would require at least two Transformer stages. You can do it with one Transformer stage and two reference input links, but both lookups will ...

I believe you will need to have DB2 Connect installed to be able to use the DB2 UDB API from a UNIX machine to access tables on an AS/400 machine.

dsobjects.dll is already a COM object. One of the objects exposed therein is a Subroutine object which can, of course, return values. But it's probably a cumbersome approach, and you need to establish a connection to DataStage using a Session object. "They" don't provide any documentation on this, ...

"Conversion in DS is none" really means that, if you have NLS enabled, the mapping within DataStage should be set to the pseudo-map NONE.

If you don't have NLS enabled, the point is moot.

The only thing I can think of is either to clean up the data in UniData and severely castigate the proponents of keys with marks in them, or to include an additional piece to your WITH phrase in the UniData stage to eliminate keys with marks, such as

Descriptions should always go in first. "Later" never comes. I will shortly post a brief essay on the process of job design. It begins without any software (yes - planning!). The very first thing to go into a job design is to add short and long descriptions. The long description is probably a lift f...

DS EE is cluster-aware. You do have to have the osh stuff on each machine, but you do not need the complete DataStage server on each machine (contrary to anything a sales person seeking extra commission may claim!). Player processes on separate machines communicate via TCP sockets, as do section lea...

You need to have installed C++ compiler ahead of DataStage. The quick fix is to re-install the DataStage server. This will not affect any existing jobs. (It will "upgrade" them to the same release!)

Most of those questions can be answered in Powerpoint - after all, everything works in Powerpoint. However, as the others have also noted, there are large, complex and, at times, subjective factors that would come into play. Perhaps you could ask the client to be more specific with the questions. Ot...

Beware of compiler compatibility issues - recompile everything with a Transformer stage, as Vincent noted, but also any BuildOps and custom parallel routines. You may also need different compiler and linker options.

Read the messages carefully - they tell you precisely what the problem is. You've set the null value property to "" (length zero), which is its default value, but you've specified the data type as string[11] so that DataStage is demanding that your null value be an eleven character string. The other...

The BASIC Transformer stage is, as Arnd suggested, quite robust, though it incurs a performance penalty as data need to be converted to the "typeless" form used by BASIC and back again. If you created a transformation that yielded a data type that was not legitimate on return, you would see a failur...

You don't need a BuildOp. Check out other stage types, such as External Filter stage.

Unless you create an "always running" DataStage job (or job sequence) that listens for the particular message you do not have any mechanism within DataStage to do what you request. You could create your own listener external to DataStage and have that trigger a DataStage job via the command line int...